LinkBack URL
About LinkBacks
Is there anything that I have to do to make macros work with a Mac?
I have many users who need to access a report and use some macros - however Mac users are reporting that the macros do not work.
What could be the issue?
Thanks!
Veronica
Is there anything that I have to do to make macros work with a Mac?
I have many users who need to access a report and use some macros - however Mac users are reporting that the macros do not work.
What could be the issue?
Thanks!
Veronica
Hi,
Yes, frustrating isn't it? I too use a Mac with 'Microsoft Excel 2004 for Mac', and it's been a constant annoyance. There are some aspects of VBA code that are completely missing when compared to the Excel for Windows. The most obvious, and the one I keep tripping over fairly frequently is the RowSource and Control Source properties for List/Combo boxes. These are not supported in the Mac version of Excel.
Can you post the macro code that doesn't work. There may be workarounds. For instance the lack of a RowSource property can be circumvented by writing .AddItem code for various cells in a range - not as elegant as simply referring to a range but that's life! I keep an old PC with a Windows version of Excel for occasions when I need to check these sorts of differences.
Thanks for taking a look at this. It's a pretty simple control button... it just hides selected columns.
Please Login or Register to view this content.
Veronica
Are these users using Excel 2008?
There's nothing in that code that will prevent it being run on Excel2004 or '98, but VB is not supported in Excel 2008.
My guess is that MicroSoft want to sell us Mac users a copy of Windows (to be run on BootCamp or some emulator) along with Excel 2007.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Hello Mike,Originally Posted by mikerickson
Yes I'd wondered about that too. Any idea how much room BootCamp needs? Presumably you either boot up with either Windows or Leopard, or can you have both open at the same time?
I've been wondering what's the best way to get to grips with Excel 2008. Either buy a basic PC which I'd only use for Excel development or install Leopard and BootCamp on my existing Mac or even swap my Mac for a beefier version. Have you any suggestions/comments?
Rgds
I'm looking down the same road.
I have heard that there is one of those (forget which) that will boot Windows only when needed.
Many of them make you choose between Windows and Mac OS at start-up, but those that invoke Windows only when needed.
I also notice that many more heavy computer users are switching to Mac, so being familiar with that environment would be a good thing.
I am pretty sure that they do not have Excel 2008 - any other reason the macro doesn't work... a workaround?
Hi,
What's that second line of code?
shouldn't it be something likePlease Login or Register to view this content.
HTHPlease Login or Register to view this content.
I'd try these modifications.
If you can get more details from your users about what "doesnt work" and what error messages (if any) are given, it would help.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks