Hi everyone,
I created a document in Excel 2003 with SP3 on my PC. It has some lovely, simple vb coding. eg the most complex is:
* hide/unhide rows/columns
* a msg box using “Worksheet_Calculate()” to prompt the user if they check two check boxes instead of only one.
There are no array formulas. All formulas are pretty simple.
Apart from me on my pc, the other 4 users will be using it on a mac with Office 2011.
Now, when they open the document, they get a message that says that some formulas or macros won’t work. I’ve had one of the guys save it on their mac then send that file back to me so I can see if anything is broken.
Everything seems to be there. They saved it as .xls – not .xlsx
Can anyone guide me to what I should look for if the vb coding and formulas seems to be intact?
Cheers.
I created a document in Excel 2003 with SP3 on my PC. It has some lovely, simple vb coding. eg the most complex is:
* hide/unhide rows/columns
* a msg box using “Worksheet_Calculate()” to prompt the user if they check two check boxes instead of only one.
There are no array formulas. All formulas are pretty simple.
Apart from me on my pc, the other 4 users will be using it on a mac with Office 2011.
Now, when they open the document, they get a message that says that some formulas or macros won’t work. I’ve had one of the guys save it on their mac then send that file back to me so I can see if anything is broken.
Everything seems to be there. They saved it as .xls – not .xlsx
Can anyone guide me to what I should look for if the vb coding and formulas seems to be intact?
Cheers.
