 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008Mack and windows
I have a command button that works fine in windows but it will not work on a mack. Why? Thanks in advance!! Mac's don't use the controls from the Control Toolbox Toolbar. Maybe you can use a button from the Forms toolbar??? > I have a command button that works fine in windows but it will not work on a > mack. Why? Thanks in advance!!  SignatureDave Peterson different/older version of excel on the mac? > I have a command button that works fine in windows but it will not work on a > mack. Why? Thanks in advance!! And there are some methods that are addressed differently on a Mac. I would review the code assigned to the command button and check each method called in VBA Help. SignatureKevin Backmann > different/older version of excel on the mac? > > > I have a command button that works fine in windows but it will not work on a > > mack. Why? Thanks in advance!! Will this work on a mack Private Sub CommandButton1_Click() Worksheets("Sent to Assembly").Range("A3:B100,c3:c100").Copy Worksheets("Parts Sent to Assembly").Range("a65000").End(xlUp).Offset(1, 0).PasteSpecial Worksheets("Sent to Assembly").Range("a3:a100,b3:B100").ClearContents Worksheets("Schedule").Range("d1,L1,a3:a100,b3:B100,d3:d100").ClearContents End Sub > And there are some methods that are addressed differently on a Mac. I would > review the code assigned to the command button and check each method called [quoted text clipped - 4 lines] > > > I have a command button that works fine in windows but it will not work on a > > > mack. Why? Thanks in advance!! The code will run, but this is the procedure that Windows Excel inserts when you add an ActiveX commandbutton to the worksheet. You need to add another button or shape and assign the macro to the new button or shape. For best results, copy the code and paste it into a regular code module, not the module corresponding to a sheet. Then rename it with something descriptive, so you know what it does. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > Will this work on a mack > [quoted text clipped - 19 lines] >> > > work on a >> > > mack. Why? Thanks in advance!! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.