Simple Macro Question/Change on "Return"
Posted on 2012-03-28
I have a worksheet (Worksheet9) that I want to "call up" via a button from any screen in my WB. I also have a button on the worksheet called up (i.e. Worksheet9) that when the macro is fired, I want it to return me to whichever WS I was on when I originally called it up.
I have placed the macro in a public Module (maybe it needs to be in This Workbook). But I don't want to go to Sheet 11..... I want to go back to whichever sheet I was originally on.
'This hides Worksheet9
Sheet9.Visible = xlSheetHidden
1.) What do I replace Sheet11 with in order to do that?
2.) Where do I put the Macro? (Module, Worksheet or This Workbook)?
Thank you in advance,