G
Guest
I have an Excel file created in Excel 2003 for windows that I never
expected to use on a Mac. Now, however, my wife has gotten a mac, and
she needs to use the file as well. When I first tried to open it, it
took forever because of the number of embedded buttons that were in it.
I didn't get much further in troubleshooting it, because I didn't have
time to do so before she left the country with her computer (a
temporary thing, I assure you).
Now, however, I don't have a Mac to troubleshoot the file on, and I'd
like to get it working before she needs to use it on her computer.
So far, I've read that ActiveX controls, embedded buttons, and API
calls can't be used. And thus far, I think I've fixed these problems.
I don't think I have any ActiveX controls (any control I've used has
been from the standard forms toolbox in windows VBA) and I don't have
API calls. I've removed all the embedded buttons and replaced them
with a toolbar that is created programmatically at Workbook_open. I
also have a custom menu that is created at Workbook_Open. I have
another toolbar that is created and closed on demand via a form and/or
macro.
I also have multiple forms that help me use the workbook efficiently.
So, two questions:
Can I expect any more difficulties that perhaps I'm not seeing right
now and could perhaps fix if I knew what they were?
Is anyone willing to troubleshoot the file on their Mac? I'm willing
to send a 'trimmed up' version.
If the answer is yes to the second: I'd most likely be looking for
answers to: Does it work? and if not, how much will it take to make it
work?
Also, thanks to Bob Greenblatt for some of the comments he has already
made on this issue.
expected to use on a Mac. Now, however, my wife has gotten a mac, and
she needs to use the file as well. When I first tried to open it, it
took forever because of the number of embedded buttons that were in it.
I didn't get much further in troubleshooting it, because I didn't have
time to do so before she left the country with her computer (a
temporary thing, I assure you).
Now, however, I don't have a Mac to troubleshoot the file on, and I'd
like to get it working before she needs to use it on her computer.
So far, I've read that ActiveX controls, embedded buttons, and API
calls can't be used. And thus far, I think I've fixed these problems.
I don't think I have any ActiveX controls (any control I've used has
been from the standard forms toolbox in windows VBA) and I don't have
API calls. I've removed all the embedded buttons and replaced them
with a toolbar that is created programmatically at Workbook_open. I
also have a custom menu that is created at Workbook_Open. I have
another toolbar that is created and closed on demand via a form and/or
macro.
I also have multiple forms that help me use the workbook efficiently.
So, two questions:
Can I expect any more difficulties that perhaps I'm not seeing right
now and could perhaps fix if I knew what they were?
Is anyone willing to troubleshoot the file on their Mac? I'm willing
to send a 'trimmed up' version.
If the answer is yes to the second: I'd most likely be looking for
answers to: Does it work? and if not, how much will it take to make it
work?
Also, thanks to Bob Greenblatt for some of the comments he has already
made on this issue.