populate upon opening

D

Db1712

Is there a way to set an workbook to request information prior to
opening. For example, when you open a an excel file it will prompt you
to enter a name (Please enter name in space below) that space will
link to and populate a specified cell or cells.
 
F

Frank Kabel

Hi
put some code in wour workbook open event of your workbook module (not
in a standard module). e.g.
public sub workbook_open()
dim res
res=inputbox "Enter a name"
me.worksheets("sheet1").range("A1").value=res
end sub
 
Top