Prev: data lookup
Next: How do I group multiple files with excel to export to other users?
From: Joe M. on 25 Jan 2010 16:01
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.
From: Dave Peterson on 25 Jan 2010 16:10
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
 | 
Pages: 1
Prev: data lookup
Next: How do I group multiple files with excel to export to other users?