Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a file (Sheet1 only used) with two Forms Command Buttons, with
Captions ToProtectWB and ToUnprotectWB. I want one to be enabled and the other disabled according to the current setting. This is what I now have **which is producing R/T 1004**. Can someone assist me? Sub ToProtectWB() ' ActiveWorkbook.Protect Password:="password", Structu=True, Windows:=False Sheets(1).Buttons("Protect WB").Enabled = False Sheets(1).Buttons("Unprotect WB").Enabled = True End Sub Sub ToUnprotectWB() ' ActiveWorkbook.Unprotect Password:="password" Sheets(1).Buttons("Unprotect WB").Enabled = False Sheets(1).Buttons("Protect WB").Enabled = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Runtime 1004 error -- insert method of range class failed. | Excel Discussion (Misc queries) | |||
Run-Time error '1004' : Select method of Range class failed | Excel Discussion (Misc queries) | |||
Unable to set the Values property of the Series class | Charts and Charting in Excel | |||
Unable to set the formula property of the series class | Charts and Charting in Excel | |||
Unable to set the XValues property of the Series class | Charts and Charting in Excel |