Important: Not all ActiveX controls can be used directly on worksheets; some can be used only on Visual Basic for Applications (VBA) UserForms. If you try to add any one of these particular ActiveX controls to a worksheet, Excel displays the message 'Cannot insert object.' Thanks for the quick reply craig49. I checked to the file extension and it is xlsm. It allows me to assign a macro to it. So I created an empty macro, then copied the code to it. Then I assigned the new macro to the button and it enables the button. I really do not want to do this with the 15 buttons I have. Any other suggestions would be appreciated. I also open the developer toolbar and disabled the design mode. This did not work either. Thanks again. I also have a code that works fine in windows but doesn't in Mac. It gives me a Compile Error - expected function or variable, and highlights 'select' on second row from bottom. Like i mentioned this code works fine in windows environment. Hello ddnron, I did some snooping around trying to find an answer. But, there aren't many answers out there! I'm sure you are finding the same. Part of the problem is while Office 2011 does have VBA in the 'feature set' the Mac version is like 'VBA Lite.' MS either chose not to include a full VBA feature set or chose one that works most of the time. ActiveX, for example is not supported in 2011. While it is documented, no mention is made that it is not supported. The previous version of Office for Mac didn't have any VBA support and apparently there was no active development for years. When it was decided to include VBA in 2011, the development team was rushed to 'catch up' with years of development on the Windows side. So, it is amazing that VBA 2011 works as well as it does. The frustrating part is that MS just says, 'It's got VBA,' and forgot the part about 'but, it isn't the fully functioning version.' That's marketing. However, it helps lots of folks make good incomes writing books and consulting. Quickbooks 2010 for mac manual. QuickBooks 2010 for Mac 2010 is compatible with any Mac containing an Intel processor and running OS X v10.5.7 or later. The application is also compatible with OS X v10.7, also known as Mountain Lion, but QuickBooks' manufacturer Intuit recommends you purchase and use the latest version of. Sorry I couldn't have been more helpful. Thanks agian for your reply craig49. My snooping has lead me in the same direction as you, there is not much out there. I'll just create macros, without code, and copy my code into them, then assign. I can go to Mac VB and run the codes from there. All except the one I posted. I'm by no means an expert at VB, but the Mac version just does not have all the functioning tools as windows. Good thing I have both operating systems in the house. I think I'll send Microsoft a note about the codes working in windows, but not Office Mac. See what they say. Thanks agian for you help and time Craig49. Hello ddnron, I did some snooping around trying to find an answer. But, there aren't many answers out there! I'm sure you are finding the same. Part of the problem is while Office 2011 does have VBA in the 'feature set' the Mac version is like 'VBA Lite.' MS either chose not to include a full VBA feature set or chose one that works most of the time. ActiveX, for example is not supported in 2011. While it is documented, no mention is made that it is not supported. The previous version of Office for Mac didn't have any VBA support and apparently there was no active development for years. When it was decided to include VBA in 2011, the development team was rushed to 'catch up' with years of development on the Windows side. So, it is amazing that VBA 2011 works as well as it does. The frustrating part is that MS just says, 'It's got VBA,' and forgot the part about 'but, it isn't the fully functioning version.' That's marketing. However, it helps lots of folks make good incomes writing books and consulting. ![]() Sorry I couldn't have been more helpful. ,, - 104 comments Form Controls What Are Form Controls? Form Controls are objects which you can place onto an Excel Worksheet which give you the functionality to interact with your models data. You can use these controls on worksheets to help select data. Keyboard shortcut for bold text on mac. For example, drop-down boxes, list boxes, spinners, and scroll bars are useful for selecting items from a list.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |