VBA Projects Locked for Viewing

[yeeteekoh]

Hi, I notice that when I lock my vba projects from viewing (protection
in VBAProject Properties) using PC, I can't view in Mac. Mac doesn't
even allow me to key in password to unlock viewing. However, if the vba
projects are created from mac and protected in mac, I am allowed the
option to key in password to unlock for viewing. Is this what it is
supposed to be or am I missing something? Thanks,

 

[JE McGimpsey]

Hi, I notice that when I lock my vba projects from viewing (protection
in VBAProject Properties) using PC, I can't view in Mac. Mac doesn't
even allow me to key in password to unlock viewing. However, if the vba
projects are created from mac and protected in mac, I am allowed the
option to key in password to unlock for viewing. Is this what it is
supposed to be or am I missing something? Thanks,

"Supposed to" is an interesting term, but yes, security options
introduced in XL03 can prevent opening projects in MacXL. Unlock the
project on the Windows machine.

Note: You should never rely on locking VBA projects for viewing for
security purposes. It takes roughly 30 seconds to remove it if you know
what you're doing.

 

[yeeteekoh]

Thanks, so it means I can't switch machines (between PC & Mac) to work
on the same file? Is there any get-around to resolve the problem? Also,
am quite puzzle about your note that I should never rely on locking VBA
projects for viewing for security purposes - but what other ways to
secure my VBA projects for viewing?

 

[JE McGimpsey]

Thanks, so it means I can't switch machines (between PC & Mac) to work
on the same file? Is there any get-around to resolve the problem?

The workaround is to leave them unprotected.

Also, am quite puzzle about your note that I should never rely on
locking VBA projects for viewing for security purposes - but what
other ways to secure my VBA projects for viewing?

Your VBA password can be bypassed in a heartbeat. Most people, of
course, don't know that, and don't know how to accomplish it.

The only relatively foolproof way to secure VBA projects is to compile
them into COM add-ins. Unfortunately, that limits them to WinXL2000 and
later.

 

[beamerman]

I have a similar problem, except I am opening the speadsheet using Excel
97. Would this be the same problem that occurs with the Mac?

Thanks,

 

[JE McGimpsey]

I have a similar problem, except I am opening the speadsheet using Excel
97. Would this be the same problem that occurs with the Mac?

I don't have access to XL97 any longer, but I wouldn't be surprised.