Userform triggered on opening of Excel

[cs1ctp]

Hi,

Was just wondering if it is possible to do the following:

Open up an Excel document stored on my computer and on opening, a userform is triggered requesting a user to log on. I understand there is a way of protecting the workbook, but I wish to customise the logon screen and fire different events depending on the user credentials.

I literally want the first thing the user sees when they open the Excel Document to be a UserForm ... Is this possible??

Many thanks in advance for your help,

Chris

 

[Norie]

Chris

It certainly is possible.

Assuming the userform exists just put something like this in the workbook's open event.

Userform1.Show

To access the Open event of a workbook:

1. Right click the small Excel icon next to File on the main toolbar and select View Code.

2. Select Workbook from the left dropdown.

3. You should now see the following code:

Private Sub Workbook_Open()

End Sub

This is where you put any code to be run when the workbook opens.

You would need code/controls in/on the userform for the rest.

 

[cs1ctp]

Perfect, Thanks Norie.