ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   PC macros won't work on MAC (https://www.excelbanter.com/excel-discussion-misc-queries/184477-pc-macros-wont-work-mac.html)

Adam

PC macros won't work on MAC
 
Hi,

I spent the last month working on a large workbook in Excel 2003 and it has
all sorts of macros in it. It works great on PC versions of Excel. However,
the macros are not working when MAC users open the workbook. Also, the
formatting of the MAC file is a bit off. Is there an easy way to make my
workbook compatible with the MAC version of Excel?

Thanks,

Adam

Niek Otten

PC macros won't work on MAC
 
Hi Adam,

What does "nor working" mean?
In Excel 2008 there is no VBA anymore.
Check the macro protection level.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Adam" wrote in message ...
| Hi,
|
| I spent the last month working on a large workbook in Excel 2003 and it has
| all sorts of macros in it. It works great on PC versions of Excel. However,
| the macros are not working when MAC users open the workbook. Also, the
| formatting of the MAC file is a bit off. Is there an easy way to make my
| workbook compatible with the MAC version of Excel?
|
| Thanks,
|
| Adam



Jon Peltier

PC macros won't work on MAC
 
Even in MacExcel prior to 2008, there are incompatibilities.

* MacExcel uses an older version of VBA than the version which was
introduced in Windows Excel 2000.
* Windows Excel has access to all manner of Windows API calls which are not
compatible with the Mac OS.
* MacExcel does not have ActiveX controls in the worksheet, which were
introduced in Windows Excel 97.

If you want to get the most out of Excel, you should join up with the 95%
of Excel users who run Excel on Windows. (I don't know what the actual
numbers are, but Mac visitors to my web site comprise less than 3% of the
total.)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Niek Otten" wrote in message
...
Hi Adam,

What does "nor working" mean?
In Excel 2008 there is no VBA anymore.
Check the macro protection level.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Adam" wrote in message
...
| Hi,
|
| I spent the last month working on a large workbook in Excel 2003 and it
has
| all sorts of macros in it. It works great on PC versions of Excel.
However,
| the macros are not working when MAC users open the workbook. Also, the
| formatting of the MAC file is a bit off. Is there an easy way to make
my
| workbook compatible with the MAC version of Excel?
|
| Thanks,
|
| Adam






All times are GMT +1. The time now is 02:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com