I am going to distribute a spreadsheet that contains some macros. Is it
possible to prevent users from being able to access the code in the macros?

Ie. stop them going Tools | Macros | Edit?

Thanks!

Danny,

Yes and strangely enough no!!

You can protect your code by going to the VB editor and then

Tools|VBProject properties|protection
lock project for viewing and apply a password..
That's the Yes bit

The No bit is because the protection is pretty flimsy and cheap commercial
software can remove the passowrd.

Mike

"DannyS" wrote:

I am going to distribute a spreadsheet that contains some macros. Is it
possible to prevent users from being able to access the code in the macros?

Ie. stop them going Tools | Macros | Edit?

Thanks!

You might make the Extra Macro option HIDE
and turn off ALT-F11
Download add-in James 2007 from www.allocator.nl
and check Maintenance option Macro.

"DannyS" wrote:

I am going to distribute a spreadsheet that contains some macros. Is it
possible to prevent users from being able to access the code in the macros?

Ie. stop them going Tools | Macros | Edit?

Thanks!

Great, thanks Mike.

The problem was that one of my Macros does an unprotect then a re-protect of
the worksheet, and therefore I have to specify the unprotect password. I
wanted to stop users from viewing the code and hence obtaining the unprotect
password.

Is the worksheet protection password just as easily cracked as the macro
protection?

Thanks again, Danny

"Mike H" wrote:

Danny,

Yes and strangely enough no!!

You can protect your code by going to the VB editor and then

Tools|VBProject properties|protection
lock project for viewing and apply a password..
That's the Yes bit

The No bit is because the protection is pretty flimsy and cheap commercial
software can remove the passowrd.

Mike

"DannyS" wrote:

I am going to distribute a spreadsheet that contains some macros. Is it
possible to prevent users from being able to access the code in the macros?

Ie. stop them going Tools | Macros | Edit?

Thanks!

Worksheet protection is more easily broken than is VBAProject protection.

See John McGimpsey's site for more info.

http://www.mcgimpsey.com/excel/removepwords.html


Gord Dibben MS Excel MVP

On Wed, 5 Sep 2007 02:54:00 -0700, DannyS
wrote:


Great, thanks Mike.

The problem was that one of my Macros does an unprotect then a re-protect of
the worksheet, and therefore I have to specify the unprotect password. I
wanted to stop users from viewing the code and hence obtaining the unprotect
password.

Is the worksheet protection password just as easily cracked as the macro
protection?

Thanks again, Danny

"Mike H" wrote:

Danny,

Yes and strangely enough no!!

You can protect your code by going to the VB editor and then

Tools|VBProject properties|protection
lock project for viewing and apply a password..
That's the Yes bit

The No bit is because the protection is pretty flimsy and cheap commercial
software can remove the passowrd.

Mike

"DannyS" wrote:

I am going to distribute a spreadsheet that contains some macros. Is it
possible to prevent users from being able to access the code in the macros?

Ie. stop them going Tools | Macros | Edit?

Thanks!