ExcelBanter - Password Prompt

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Password Prompt (https://www.excelbanter.com/excel-discussion-misc-queries/16627-password-prompt.html)

LuhElle

Password Prompt

I have a file that is set to prompt for a password at startup for write
access. I would like to give someone a copy of the file that is not set to
prompt for password. How do I remove the protection. I don't want to give
out the password.

Gord Dibben

FileSave AsToolsGeneral Options.

Delete the password from here and save the workbook with a new name.

Send that to the "someone".

Gord Dibben Excel MVP

On Tue, 8 Mar 2005 08:53:01 -0800, "LuhElle"
wrote:

I have a file that is set to prompt for a password at startup for write
access. I would like to give someone a copy of the file that is not set to
prompt for password. How do I remove the protection. I don't want to give
out the password.

All times are GMT +1. The time now is 11:15 PM.