-
From Template file Force Save and Close
A User opens my template and immediately they are asked for their choice of filesavename and folder.
Code runs, some sheets are made visible, some hidden.
A sheet for user input is displayed and the user has control.
User will add their data and then click a button on the sheet.
The button runs a sub which sends emails based on the user input.
What I would like to achieve, but cannot, is as follows:
After the file name and save folder is secured, I wish to force that name and path if the user quits, saves, cancels etc.
and also to save as a macro-free workbook.
What code do I need and where to place it please?
Regards.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules