G
Guest
i am writing a program that has numerous workshhets that are hidden. I wnat
the user to enter a worksheet name and the program to make that sheet asked
for visible.
ie
Dim Message, Title, Default, MyValue
Message = "Enter a sheet name" ' Set prompt.
Title = "" ' Set title.
Default = "" ' Set default.
' Display message, title, and default value.
MyValue = InputBox(Message, Title, Default)
Worksheets(MyValue).Visible = True
any ideas
the user to enter a worksheet name and the program to make that sheet asked
for visible.
ie
Dim Message, Title, Default, MyValue
Message = "Enter a sheet name" ' Set prompt.
Title = "" ' Set title.
Default = "" ' Set default.
' Display message, title, and default value.
MyValue = InputBox(Message, Title, Default)
Worksheets(MyValue).Visible = True
any ideas