+ Reply to Thread
Results 1 to 8 of 8

Coding with hidden sheets

  1. #1
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Coding with hidden sheets

    Till now I have used code such as
    Please Login or Register  to view this content.
    to refresh pivots.
    I would like to keep the Sheet hidden and have tried to use code such as
    Please Login or Register  to view this content.
    This does not work

    Also I have found that when a sheet is hidden code such as
    Please Login or Register  to view this content.
    does not work
    I think I am probably not understanding something and would welcome some help.
    John

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Coding with hidden sheets

    you can't select anything on a hidden sheet (or any sheet that isn't the active one) but you don't need to for that
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Re: Coding with hidden sheets

    JosephP

    Thanks for that, It looks obvious now! My trouble is I am self taught and have used Macro generated code as in this case.
    Can you help me on the Goto Reference:= "Named Range". I dont want the sheet on which the named range resides to be visible, and this code seems to require that it is.
    John

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Coding with hidden sheets

    can't be done- like I said you can't select anything on a hidden sheet. why do you (think you) need to use Goto?

  5. #5
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Re: Coding with hidden sheets

    I use it in a little Paste Down sub routine.
    I originally coded it after running a Macro. I have just looked at it again and I probably dont need to use Goto.

    I'll try some alternatives and come back if I hit problems
    Thanks very much for your help
    John

  6. #6
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Coding with hidden sheets

    If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

    Remember to post new questions as new threads so as to best incur rapid responses from new eyes. Threads with 0 or 1 responses in them garner the most immediate attention. Were you to continue posting in this thread, pretty much only the current subscribers would respond leading to unneeded and possibly lengthy delays.

  7. #7
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Coding with hidden sheets

    Quote Originally Posted by JBeaucaire View Post
    Were you to continue posting in this thread, pretty much only the current subscribers would respond
    who else do you need? ;-P

  8. #8
    Forum Contributor
    Join Date
    03-30-2010
    Location
    Manchester England
    MS-Off Ver
    Excel 2010
    Posts
    992

    Re: Coding with hidden sheets

    I have now managed to recode all the GoTo Reference:= situations and can keep the sheets hidden. Thanks for your help.
    John

+ 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