Macro protection problems
 

I have about 20 worksheets in a workbook. I am using a macro to protect them
all. One worksheet has a "control" panel with some command buttons. When I
protect the ws containing the control panel, the buttons can still be pushed
even though the cells are protected. Is there a way to protect the buttons
too?

Thanks,
Joe M.

Macro protection problems
 

You could disable the commandbuttons on that sheet when you protect the
worksheet that owns them.

With Worksheets("SheetNameHere")
.Protect Password:="hi"
.CommandButton1.Enabled = False
.CommandButton2.Enabled = False
End With



Joe M. wrote:

I have about 20 worksheets in a workbook. I am using a macro to protect them
all. One worksheet has a "control" panel with some command buttons. When I
protect the ws containing the control panel, the buttons can still be pushed
even though the cells are protected. Is there a way to protect the buttons
too?

Thanks,
Joe M.

--

Dave Peterson