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

You can put a line of code or two just before your main code, something
like:

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

Now if the windows logon name is not equal to Simon or Bob the sub will
exit everytime!

Beverly Darvill;263256 Wrote:
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


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=73487

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



"Simon Lloyd" wrote:


You can put a line of code or two just before your main code, something
like:

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

Now if the windows logon name is not equal to Simon or Bob the sub will
exit everytime!

Beverly Darvill;263256 Wrote:
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


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=73487

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



"Gary Brown" wrote:

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



"Simon Lloyd" wrote:


You can put a line of code or two just before your main code, something
like:

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

Now if the windows logon name is not equal to Simon or Bob the sub will
exit everytime!

Beverly Darvill;263256 Wrote:
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


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=73487

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)



On Tue, 10 Mar 2009 16:04:41 +0000, Simon Lloyd
wrote:


You can put a line of code or two just before your main code, something
like:

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

Now if the windows logon name is not equal to Simon or Bob the sub will
exit everytime!

Beverly Darvill;263256 Wrote:
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