Results 1 to 10 of 18

Thread: Hide Unhide Picture And Cell Content Using CheckBoxes

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member
    Join Date
    Jul 2013
    Posts
    102
    Rep Power
    13
    use the following code but get a error-expected named parameter

    Code:
    Sub Auto_Open()
    With Worksheets("sheet1")
    .Unprotect Password:="hello" ' If there's a password, use it within the double quote
    .Protect UserInterfaceOnly:=True, Password="hello"' If there's a password, use it within the double quote
    End With
    End Sub

  2. #2
    Senior Member
    Join Date
    Jul 2013
    Posts
    102
    Rep Power
    13
    I fixed a typo as you suggested so the code does not give error but it still allows me to delete the cell contents and it does not ask for passwords

    Thanks

Similar Threads

  1. VBA To Hide And Unhide Rows
    By paul_pearson in forum Excel Help
    Replies: 10
    Last Post: 05-08-2013, 03:14 AM
  2. Hide/Unhide Columns with Listbox
    By obed_cruz in forum Excel Help
    Replies: 2
    Last Post: 05-28-2011, 07:26 PM
  3. Hide and Unhide Rows and Columns
    By Admin in forum Download Center
    Replies: 0
    Last Post: 05-11-2011, 12:00 AM
  4. Replies: 2
    Last Post: 05-06-2011, 02:59 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •