Coding with hidden sheets

[j_Southern]

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

[JosephP]

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.

[j_Southern]

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

[JosephP]

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?

[j_Southern]

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

[JBeaucaire]

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.

[JosephP]

Were you to continue posting in this thread, pretty much only the current subscribers would respond

who else do you need? ;-P

[j_Southern]

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