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!