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

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.

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

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?

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

Originally Posted by JBeaucaire

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

who else do you need? ;-P

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