View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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