Password protected macro

[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

 

[Gary Brown]

a QUICK GOOGLE WILL BRING YOU TO...
http://www.ifsconnect.com/
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown

 

[Gary Brown]

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

 

[Chip Pearson]

If environ("username")<> "Simon" Or
environ("username")<> "Bob" Then Exit Sub

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)