+ Reply to Thread
Results 1 to 2 of 2

macro doesn't work on hidden sheets

  1. #1
    Registered User
    Join Date
    06-05-2009
    Location
    Charlotte
    MS-Off Ver
    Excel 2007
    Posts
    19

    macro doesn't work on hidden sheets

    I have several sheets that I'd like to hide from view to prevent users from doing things they should not do. The macros do various sorts and export updates to other workbooks. Is it not possible to hide sheets and make calls to them? I get a run-time error '1004' select method of worksheet class failed.
    If I can't hide these sheets, can I prevent users from selecting these sheets for viewing? Any ideas?

    JS

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: macro doesn't work on hidden sheets

    You can't select cells on hidden sheets, but there's no need to select them to operate with or on them.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

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