Password protected macro

  • Thread starter Thread starter Beverly Darvill
  • Start date Start date
B

Beverly Darvill

Is there a way to password protect a macro.

The workbook it will run in is already password protected but I don't want
other users (they open it in Read Only with on the Administrators opening it
full mode) inadvertantly clicking the macro although it won't cause any
problem if they do just will stop them from viewing the workbook for about 5
mins dependant on the number of worksheets the macro has to update.

Thanks
 
Wrong post...AND sorry for SHOUTING :O<
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown
 
If environ("username")<> "Simon" Or
environ("username")<> "Bob" Then Exit Sub
Click to expand...


You need an AND not an OR.

If Environ("username") <> "Simon" And _
Environ("username") <> "Bob" Then Exit Sub

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Back
Top