Personalizing a macro based on user input
 

Each time this macro is run, it's done on a brand new spreadsheet, so storing
it in the current spreadsheet wouldn't work.

Is it possible to programmatically store the information input by the user
to the PERSONAL.XLS spreadsheet, save the PERSONAL.XLS spreadsheet so they
don't get prompted when closing Excel, and then go get that information the
next time a new spreadsheet is opened?

"Gary''s Student" wrote:

Sure. Once the user has supplied the info, have the macro store it in some
cells somewhere.

The next time the program runs, the macro should first look at the storage
area and ask for data only if it is empty.
--
Gary''s Student - gsnu201001


"Dee Sperling" wrote:

The macro prompts for the user's name and email address. Is there any way to
have the macro store that information for the next time, instead of asking
each time it's run?

Thank you,
Dee Sperling