MRK_Toledo
09-03-2006, 09:23 AM
:help Here is what I have.....
I have made an excel workbook that has multiple sheets in it.
- I would like to keep the DEFAULT copy, and force the user to SAVE AS
- I would like to accomplish this through a message box
- I would like the SAVE AS to automatically enter a filename based on
info contained in a specific cell on a specific worksheet
- I would also like the SAVE AS to automatically point to the correct folder
In addition....
I would also like to be able to EXPIRE my workbook after a period of days.
- If the workbook expires in 90 days, then I would like for a message box
to open up each time the workbook opens reminding the user that
they only have 'x' days to renew their license.
- If that time passes ans they no not, I would like for them to be taken to
a seperate sheet in the workbook that only displays contact info and
info on how to get a fresh license, everything else will be locked out.
The fresh license will be a new updated file that they will be emailed.
This workbook does not contain any customer entered data, only reference information, so there will be no need to save their info upon expiring the app.
:dunno I have tried everything to get this to work, an I have had no luck. I have basically decided to start over from scratch and ask some of the experts that might be on the board.
Any help that you can provide will be greatly appreciated.
Thanks in Advance.
I have made an excel workbook that has multiple sheets in it.
- I would like to keep the DEFAULT copy, and force the user to SAVE AS
- I would like to accomplish this through a message box
- I would like the SAVE AS to automatically enter a filename based on
info contained in a specific cell on a specific worksheet
- I would also like the SAVE AS to automatically point to the correct folder
In addition....
I would also like to be able to EXPIRE my workbook after a period of days.
- If the workbook expires in 90 days, then I would like for a message box
to open up each time the workbook opens reminding the user that
they only have 'x' days to renew their license.
- If that time passes ans they no not, I would like for them to be taken to
a seperate sheet in the workbook that only displays contact info and
info on how to get a fresh license, everything else will be locked out.
The fresh license will be a new updated file that they will be emailed.
This workbook does not contain any customer entered data, only reference information, so there will be no need to save their info upon expiring the app.
:dunno I have tried everything to get this to work, an I have had no luck. I have basically decided to start over from scratch and ask some of the experts that might be on the board.
Any help that you can provide will be greatly appreciated.
Thanks in Advance.