Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding rows based on user input | Excel Programming | |||
Autofilter based on user input? | Excel Programming | |||
need help w/ macro prompting with info and pasting the info based on user input | Excel Programming | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
select data based on user input | Excel Programming |