harleyberger
New Member
- Joined
- May 1, 2003
- Messages
- 37
I have an Excel spreadsheet that was created on a PC that uses macros. In order for the spreadsheet to work properly on a PC we must load the Microsoft Windows Common Controls-2 6.0 (SP6). We do this work by saving the mscomct2.ocx file to the hard drive of the PC and then entering this command in the run box: regsvr32 c:\windows\system32\mscomct2.ocx
Once this is done, the spreadsheet and macros work fine on a PC.
I'm trying to get this same spreadsheet to work on a Mac. I can get the spreadsheet to open on the Mac, but the macros don't work. If I go to the references table in the VB editor, obviously the MS Windows Common Controls is not listed.
Is there any way to get my spreadsheet that works on a PC to work on a Mac?
Once this is done, the spreadsheet and macros work fine on a PC.
I'm trying to get this same spreadsheet to work on a Mac. I can get the spreadsheet to open on the Mac, but the macros don't work. If I go to the references table in the VB editor, obviously the MS Windows Common Controls is not listed.
Is there any way to get my spreadsheet that works on a PC to work on a Mac?