Welcome message

[Akashwani]

Good day,

When a workbook is opened, is it possible to have a "welcome" message appear before the worksheets can be accessed?

I would like to create a "message" and two boxes that say "enter your name" and "enter your password".
These will be dummy boxes, but the user wont know that

Ak

 

[VoG]

Try this: right click the Excel logo just to the left of File on the menu bar, select View Code and paste in

Private Sub Workbook_Open()
Dim s As String
s = InputBox("Enter name")
s = InputBox("Enter password")
End Sub

 

[Akashwani]

Hi VoG,

I'm on 2007 and that doesn't work!

Ak

 

[Akashwani]

Ooops!

I should have said right click etc doesn't work!

Sorry.

Ak

 

[VoG]

Press ALT + F11 to open the Visual Basic Editor, in the left hand pane double click ThisWorkbook then paste in the code.

 

[Akashwani]

I'm sorry VoG if I appear to be dumb,

I have done alt-F11 and I do not see a left hand pane or "thisworkbook"

am I missing something here?

Ak

 

[VoG]

After pressing ALT + F11 you should see something like this:

 

[jeffreybrown]

As VoG states, Press ALT + F11 to open the Visual Basic Editor, once you are in there on the left hand side of the screen you should see something that says, VBAProject and then in () the name of the Excel workbook you are using. If the + is not expanded then expand it and then you will see ThisWorkbook.

 

[Akashwani]

No, I don't get that!

I just get the main screen, no side panel.

Ak

 

[VoG]

Click View > Project Explorer.