Prevent end users from manually running or recording macros

[Bill Murphy]

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

 

[Township of East Hanover]

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