In Excel 2003. how can I restrict different users within the same file from
running the same macro? Is there a way to password protect a macro so that
only the designated user with the correct password can run the macro
(currently I'm using buttons to initiate the macros)?

There are two schoolso f thought on getting the user name, some like the
'Environ' method, some prefer to to use an API call, as it can be a little
more secure. There is an example of using the API method at
http://www.nwarwick.co.uk/Finding_User_Name.htm

See which you prefer.

HTH

Neil
www.nwarwick.co.uk

"JAL" wrote:

In Excel 2003. how can I restrict different users within the same file from
running the same macro? Is there a way to password protect a macro so that
only the designated user with the correct password can run the macro
(currently I'm using buttons to initiate the macros)?