View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Russ3Z Russ3Z is offline
external usenet poster
 
Posts: 3
Default Prompt for user information at startup

I wish to prompt the user to enter various name and company
information when they first run a certain spreadsheet. The
information is then taken and entered on a sheet in the appropriate
areas automatically, serving as a future template.

So, a series of Prompt "Input Company name:" var A statements, for
example.

The question then is, is there a good way to encode this to run only
the first time the spreadsheet is run, or is it simply a case of
having to have the code on the Workbook's code page and have it check
to see if the information is already there, each time it opens?

Your help is most appreciated.
Russ