MWE
07-19-2013, 03:01 PM
I recently ran several xls files on a MAC running Excel2011 (essentially xl2010 for a MAC) and found some strange differences:
if a vbaproject is password protected on the PC, you can not view it on the MAC. The password is rejected as incorrect.
One of the procedures I tested sequences down a tab doing different things depending on what it finds in Col 1. Menu_Number = MenuSheet.Cells(Row, 1).Value
Select Case Menu_Number
Case -1 ' end of useful data, cleanup and exit sub
GoTo CleanUp
Case 0 ' start of new menu
This procedure has run without error on several different computers running xl2000, xl2003, xl2007 and xl2010 over the last 10+ years. It fails on the MAC running xl2011. Is this possibly an example of the two systems (PC vs MAC) having slightly different "values" for "-1"
if a vbaproject is password protected on the PC, you can not view it on the MAC. The password is rejected as incorrect.
One of the procedures I tested sequences down a tab doing different things depending on what it finds in Col 1. Menu_Number = MenuSheet.Cells(Row, 1).Value
Select Case Menu_Number
Case -1 ' end of useful data, cleanup and exit sub
GoTo CleanUp
Case 0 ' start of new menu
This procedure has run without error on several different computers running xl2000, xl2003, xl2007 and xl2010 over the last 10+ years. It fails on the MAC running xl2011. Is this possibly an example of the two systems (PC vs MAC) having slightly different "values" for "-1"