Protecting while still allowing macros to run

[Tammy]

Hi,

I have a spreadsheet with macros that update formulas in cells. Is there any
way of protecting the worksheet while still allowing the user to run the
macros.

 

[Shane Devenshire]

Hi Tammy,

If you use VBA to turn on protection you can look in the help system for the
arguments for Protect and you will find one called UserInterfaceOnly:=True
which allows the macro to run in a protected workbook, but doesn't allow
users to modify stuff manually.

Cheers,
Shane Devenshire