how do I program for a 'generic' worksheet to open
 

I am trying to write a program in excel visual basics. My progam has
numerous worksheets and I would like the user to input from an inputfunction
box the worksheet to access and then have the program open and display that
worksheet.

ie

Dim Message, MyValue
Message = "Enter a sheet name" ' Set prompt.
MyValue = InputBox(Message, Title, Default)
Worksheets(MyValue).Visible = True

I want the user's input to open a worksheet with that name.

any help would be most welcome. thanks

how do I program for a 'generic' worksheet to open
 

close --
use select not visible
...
Dim Message, MyValue
Message = "Enter a sheet name" ' Set prompt.
MyValue = InputBox(Message, Title, Default)
Worksheets(MyValue).Select


-----Original Message-----
I am trying to write a program in excel visual basics.
My progam has
numerous worksheets and I would like the user to input
from an inputfunction
box the worksheet to access and then have the program
open and display that
worksheet.

ie

Dim Message, MyValue
Message = "Enter a sheet name" ' Set prompt.
MyValue = InputBox(Message, Title, Default)
Worksheets(MyValue).Visible = True

I want the user's input to open a worksheet with that
name.

any help would be most welcome. thanks


.