Pop Up Box
 

Is it possible to set up a pop up box when you open a saved excel document. I
want a reminder to come up for users when they open a mileage spreadsheet I
have designed to prompt them to enter their name. Is this possible? Or is
there another funky way to do it?
Thanking you in advance!

Laura

Possible, yes. What do you want to do with the inputted name?

The following places the name in the activecell.

You could hard code a cell like Range("A1").Value = user_name

Private Sub Workbook_Open()
user_name = InputBox("Enter your Name")
ActiveCell.Value = user_name
End Sub

Note: if users disable macros the code will not run.


Gord Dibben Excel MVP

On Tue, 17 May 2005 10:15:43 -0700, "Laura"
wrote:

Is it possible to set up a pop up box when you open a saved excel document. I
want a reminder to come up for users when they open a mileage spreadsheet I
have designed to prompt them to enter their name. Is this possible? Or is
there another funky way to do it?
Thanking you in advance!