Protecting Macro Toolbar selection in Workbook

[Bowdlerb]

I have hidden and protected my workbook using the "Protect Workbook" command and included the password within the macro. The 'edit' facility in the Macro option in the drop-down Toolbar still appears to be available, allowing the user to read the VB. Is there a way of locking out the option to see the VB?[/code]

 

[TommyGun]

Go into the VBA editor, and right-click on the project. Select "properties" and in the dialog box click on the "protection" tab. Check "lock project for viewing" and then supply a password. Save your workbook and close. Now you have to provide a password to view your code.

 

[Smitty]

Welcome to the Board!

There are several thing that you can do. The first and simplest would be to password protect your VBA code. In VBA goto Tools --> VBA Project Properties --> LockProject for viewing --> Enter Password.

If you want something more, post back. There are ways to eliminate all or part of the command bars and menus.

Hope that helps,

Smitty

 

[Bowdlerb]

thanks for the information. I tried what you suggested but upon saving and re-entering the file, I can still read the macros which will show the password I have entered into the code. Any other ideas?

 

[TommyGun]

Are you sure you protected the right VBA project? What do you mean by "read the macros"?

 

[Bowdlerb]

You are quite right, I had not chosen the correct VB Project. I have no re-tried your instructions and it has worked fine. Thanks so much - Barrie Bowdler