PDA

View Full Version : Solved: Goto a worksheet selected by the user



Audax
04-16-2007, 08:12 AM
Hi experts

Is there a VBA which after run the macro, ask me the name of the worksheet and after typing the name open that worksheet?

Thank you

Bob Phillips
04-16-2007, 08:38 AM
sName = Inputbox ("Supply worksheet name")
Worksheets(sName).Activate

Audax
04-16-2007, 08:52 AM
Thank a lot XLD