Thank you again and have a great weekend

"Gary''s Student" wrote:

It just insures that a String gets returned and not a number.

By the way, I don't know how to do the password thing.
--
Gary''s Student - gsnu200811


"Eduardo" wrote:

Gary just a question what Type:=2 means

"Gary''s Student" wrote:

Sub sheet_picker()
Dim s As String
s = Application.InputBox(prompt:="enter sheetname:", Type:=2)
Sheets(s).Activate
End Sub
--
Gary''s Student - gsnu200811