Prevent end users from manually running or recording macros
 

you can put something like this in a file that excel loads at startup:

Application.CommandBars("Edit").Controls("Delete.. .").Enabled = False

The above command disables the delete option under the edit menu. You can
then hide the file that excel loads at startup so that the users can't find
it to change it.

Rui

"Bill Murphy" wrote in message
...
End users can manually run macros or record new ones by selecting
Tools/Macros while in the workbook. Is there a way to password protect
the
Macros choice on this menu so that only the system administrator or other
authorized users can do this?

Bill