PDA

View Full Version : From Template file Force Save and Close



stuartgb100
11-30-2016, 11:17 AM
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.