Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|