Protecting while still allowing macros to run

  • Thread starter Thread starter Tammy
  • Start date Start date
T

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.
 
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
 
Back
Top