Remove password

[Saul Margolis]

My excel app opens a password protected excel template (thus opening
an excel workbook based on the template). It then populates the
workbook with some data and presents it to the user.

I would then like to remove the password on the workbook, so that if
the user wishes to save, he will not have to click Save As, Options
and set Password To Open to blank. The problem is that sometimes the
user forgets to remove the password, and I then have to open the
workbook using the password and resave it for him.

I know that one can SaveAs without the password, however this is not
the ideal solution since the user may wish to view the data before he
decides whether or not to save.

Is there a way of setting the workbook password to blank without
prompting the user to save?


Regards,
Saul

 

[Jim Rech]

It sounds as if you have macros running. If so, you might consider adding
to them to create a new workbook by copying the sheet(s) in your template
workbook to a new workbook. And then close the template so the user is left
with an unsaved new workbook that will not be password protected.