cell protection
 

On a form, there are certain cells that I have locked so that they can't be
changed. Most of the cells are unlocked. Also on the sheet I have several
buttons that I have assigned macros to. When I protect the sheet and try to
run the macros I get an error message. What do I need to do to protect the
sheet and get the macros to run? Thanks.

cell protection
 

A button should be clickable to run a macro even on a protected sheet. But
if the macro does something that requires an unprotected sheet the macro
might have to include the unprotecting and reprotecting of the sheet.

A possible alternative is to protect the sheet using the UserInterfaceOnly
perimeter of the of the worksheet Protect method (see Help). For most
actions the macro would not then have to do the unprotect/reprotect.

--
Jim
"ckane" wrote in message
...
| On a form, there are certain cells that I have locked so that they can't
be
| changed. Most of the cells are unlocked. Also on the sheet I have
several
| buttons that I have assigned macros to. When I protect the sheet and try
to
| run the macros I get an error message. What do I need to do to protect
the
| sheet and get the macros to run? Thanks.