Results 1 to 2 of 2

Error 1004 (unable to set the hidden property of the range class)

Threaded View

  1. #1
    Registered User
    Join Date
    03-13-2011
    Location
    singapore
    MS-Off Ver
    Excel 2003, Excel 2007
    Posts
    10

    Error 1004 (unable to set the hidden property of the range class)

    Hi,

    I am having some issues with my excel marco that was being done by another colleague of mine ...

    I have attached the command for the macro,

    Sub RestoreAll()
    '
    ' RestoreAll Macro
    ' Macro recorded 06-01-2010 by xxx'
    
    '
        Sheets("Projects").Protect Password:="anna", _
            UserInterFaceOnly:=True
        ActiveSheet.Protect Password:="anna", DrawingObjects:=True, Contents:=True, Scenarios:=True _
            , AllowInsertingRows:=True, AllowDeletingRows:=True, AllowFiltering:=True
        Columns("A:AM").Select
        Selection.EntireColumn.Hidden = False
        Selection.AutoFilter Field:=3
        Range("A2").Select
    End Sub
    regards,
    Alex
    Attached Images Attached Images
    Last edited by pike; 03-13-2011 at 11:16 PM. Reason: add code tags for newbie pm rule

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1