running a macro on a protected sheet

Giganews Newsgroups
Subject: running a macro on a protected sheet
Posted by:  kriss (knicho…@huttig.com)
Date: Thu, 23 Oct 2003

I've got a scenario where I've got several option buttons
in groups to make choices.  I've got the sheet protected
so the buttons and/or groups can't be accidentally moved
by the user.  However, I've created a "clear all" button
so the user can reset the form to redo their option button
choices, if they need to.  But, when protected, the macro
attached to the "clear all" button won't work (due to the
protection).  How do I get around this?  Thanks!

Replies