Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
1004 - Unable to set the hidden property of the range class
I'm getting the error mentioned in the subject line when I initially click
(first open the workbook) on either of the command buttons associated with the code below. Once I manually unprotect the worksheet, the command buttons work correctly. Any help would be appreciated. When you click the protect button, the sheet should hide the billing information, protect the sheet from being edited and save the sheet. When you click the unprotect button, it should ask you for the password and unhide the information. I'm using VBA for Excel 2003. Thanks in advance for any help. Private Sub CommandButton1_Click() ' ' Protect Macro ' Macro recorded 02/16/2006 by Tim Whitley ' ' Keyboard Shortcut: Ctrl+Shift+M ' Rows("33:40").Select Selection.EntireRow.Hidden = True ActiveSheet.Protect Password:="show$", Contents:=True, _ Scenarios:=False, DrawingObjects:=True, _ UserInterfaceOnly:=True ActiveWorkbook.Save End Sub Private Sub CommandButton2_Click() ' ' Unlockit Macro ' Macro recorded 02/17/2006 by Tim Whitley ' ' Keyboard Shortcut: Ctrl+Shift+O 'must lock VBA project so you can't see the password in it Dim MyStr1 As String, MyStr2 As String MyStr2 = ("show$") 'This is the password and it is CASE sensitive MyStr1 = InputBox("Password Required") If MyStr1 = MyStr2 Then Rows("33:40").Select Selection.EntireRow.Hidden = False ActiveSheet.Unprotect Password:=MyStr1 Else MsgBox ("Access Denied") End If |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
1004 - Unable to set the hidden property of the range class
Just unprotect it before hiding anything.
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Tim Whitley" wrote in message ... I'm getting the error mentioned in the subject line when I initially click (first open the workbook) on either of the command buttons associated with the code below. Once I manually unprotect the worksheet, the command buttons work correctly. Any help would be appreciated. When you click the protect button, the sheet should hide the billing information, protect the sheet from being edited and save the sheet. When you click the unprotect button, it should ask you for the password and unhide the information. I'm using VBA for Excel 2003. Thanks in advance for any help. Private Sub CommandButton1_Click() ' ' Protect Macro ' Macro recorded 02/16/2006 by Tim Whitley ' ' Keyboard Shortcut: Ctrl+Shift+M ' Rows("33:40").Select Selection.EntireRow.Hidden = True ActiveSheet.Protect Password:="show$", Contents:=True, _ Scenarios:=False, DrawingObjects:=True, _ UserInterfaceOnly:=True ActiveWorkbook.Save End Sub Private Sub CommandButton2_Click() ' ' Unlockit Macro ' Macro recorded 02/17/2006 by Tim Whitley ' ' Keyboard Shortcut: Ctrl+Shift+O 'must lock VBA project so you can't see the password in it Dim MyStr1 As String, MyStr2 As String MyStr2 = ("show$") 'This is the password and it is CASE sensitive MyStr1 = InputBox("Password Required") If MyStr1 = MyStr2 Then Rows("33:40").Select Selection.EntireRow.Hidden = False ActiveSheet.Unprotect Password:=MyStr1 Else MsgBox ("Access Denied") End If |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
1004 - Unable to set the hidden property of the range class
Try this:
ActiveSheet.Unprotect Password:=MyStr1 Rows("33:40").Select Selection.EntireRow.Hidden = False You need to unlock the sheet before you can unhide the rows. -- Ian -- "Tim Whitley" wrote in message ... I'm getting the error mentioned in the subject line when I initially click (first open the workbook) on either of the command buttons associated with the code below. Once I manually unprotect the worksheet, the command buttons work correctly. Any help would be appreciated. When you click the protect button, the sheet should hide the billing information, protect the sheet from being edited and save the sheet. When you click the unprotect button, it should ask you for the password and unhide the information. I'm using VBA for Excel 2003. Thanks in advance for any help. Private Sub CommandButton1_Click() ' ' Protect Macro ' Macro recorded 02/16/2006 by Tim Whitley ' ' Keyboard Shortcut: Ctrl+Shift+M ' Rows("33:40").Select Selection.EntireRow.Hidden = True ActiveSheet.Protect Password:="show$", Contents:=True, _ Scenarios:=False, DrawingObjects:=True, _ UserInterfaceOnly:=True ActiveWorkbook.Save End Sub Private Sub CommandButton2_Click() ' ' Unlockit Macro ' Macro recorded 02/17/2006 by Tim Whitley ' ' Keyboard Shortcut: Ctrl+Shift+O 'must lock VBA project so you can't see the password in it Dim MyStr1 As String, MyStr2 As String MyStr2 = ("show$") 'This is the password and it is CASE sensitive MyStr1 = InputBox("Password Required") If MyStr1 = MyStr2 Then Rows("33:40").Select Selection.EntireRow.Hidden = False ActiveSheet.Unprotect Password:=MyStr1 Else MsgBox ("Access Denied") End If |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
1004 - Unable to set the hidden property of the range class
Thanks for your help Bob and Ian...problem solved.
"Tim Whitley" wrote: I'm getting the error mentioned in the subject line when I initially click (first open the workbook) on either of the command buttons associated with the code below. Once I manually unprotect the worksheet, the command buttons work correctly. Any help would be appreciated. When you click the protect button, the sheet should hide the billing information, protect the sheet from being edited and save the sheet. When you click the unprotect button, it should ask you for the password and unhide the information. I'm using VBA for Excel 2003. Thanks in advance for any help. Private Sub CommandButton1_Click() ' ' Protect Macro ' Macro recorded 02/16/2006 by Tim Whitley ' ' Keyboard Shortcut: Ctrl+Shift+M ' Rows("33:40").Select Selection.EntireRow.Hidden = True ActiveSheet.Protect Password:="show$", Contents:=True, _ Scenarios:=False, DrawingObjects:=True, _ UserInterfaceOnly:=True ActiveWorkbook.Save End Sub Private Sub CommandButton2_Click() ' ' Unlockit Macro ' Macro recorded 02/17/2006 by Tim Whitley ' ' Keyboard Shortcut: Ctrl+Shift+O 'must lock VBA project so you can't see the password in it Dim MyStr1 As String, MyStr2 As String MyStr2 = ("show$") 'This is the password and it is CASE sensitive MyStr1 = InputBox("Password Required") If MyStr1 = MyStr2 Then Rows("33:40").Select Selection.EntireRow.Hidden = False ActiveSheet.Unprotect Password:=MyStr1 Else MsgBox ("Access Denied") End If |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run Time Error 1004 Unable to set hidden property | Excel Programming | |||
Unable to set the Locked property of the range class | Excel Programming | |||
Run time error 1004 - Unable to get add property of the buttons class | Excel Programming | |||
Runtime 1004 unable to get find property of range class | Excel Programming | |||
Run-time error '1004' - Unable to set the Visible property of the Worksheet class | Excel Programming |