Windows 2004 Excel vba to Mac 2004 Excel VBA

[saker]

I'm new to the mac and ported several of my excel worksheet from
Windows 2004 Excel to the Mac Excel 2004. When I tried to open the
VBA module, I can't. I get a message that the module is "Locked".
Help is no help...tells me to go to the tools menu Security where I
also am told it is "Locked". I can't figure out how to unlock it. I
assume there will be some modifications required to the module, but
can't even get it to open. What am I missing?

 

[JE McGimpsey]

I'm new to the mac and ported several of my excel worksheet from
Windows 2004 Excel to the Mac Excel 2004. When I tried to open the
VBA module, I can't. I get a message that the module is "Locked".
Help is no help...tells me to go to the tools menu Security where I
also am told it is "Locked". I can't figure out how to unlock it. I
assume there will be some modifications required to the module, but
can't even get it to open. What am I missing?

WinXL2002/3 (not 2004 - that's Mac-only) have additional security modes
that can prevent opening in MacXL. Unprotect them in XL03, then transfer
them again.

 

[saker]

WinXL2002/3 (not 2004 - that's Mac-only) have additional security modes
that can prevent opening in MacXL. Unprotect them in XL03, then transfer
them again.

Thanks! Tried it and it worked...is there a good resource to find out
information like this--difference between Mac and Windows VBA? I saw
something but it had to do with the '95 versions. Anything re:
current versions of VBA, and differences?