MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Creating a password for a macro


Posted by Tyler Hart on June 15, 2001 10:23 AM

I need to password protect certain macro inside a excel spreadsheet so some user are not able to access it.

Any suggestions


Posted by Thomas Venn on June 15, 2001 12:21 PM

press Alt+F11 for visual basic editor. If your Project Explorer is not already displayed, click on View->Project Explorer. Right click on the Module which contain your macro, choose VBA Project Properties, click on the Protection tab, at this point, you are able to set a password for your macro.

cheers,

-thomas