Jan 03 2022 02:45 AM
I will start from the beginning to make sure you understand:
I right click on the file which is protected
Dialog box for password opens, but this dialog box is for the "copy file"
If I enter the password for the "copy file" it opens a grey blank excel file (print screen below)
After this I close the "copy" grey excel file
Dialog box for the original file opens
I enter the password and is all good...
If I don't enter the password for the copy file, then every time I push "save" I get this dialog box for the copy fie to introduce the password.
Jan 03 2022 02:47 AM
Jan 03 2022 03:21 AM
Link:Protection and security in Excel
Notes: Protecting the workbook is not the same as protecting an Excel file or a worksheet with a password. See below for more information:
To lock your file so that other users can't open it, see Protect an Excel file.
To protect certain areas of the data in your worksheet from other users, you have to protect your worksheet. For more information, see Protect a worksheet.
To know the difference between protecting your Excel file, workbook, or a worksheet, see Protection and security in Excel.
Additional Links:
Link:Password Options
Link:How to unprotect the excel sheet if forgot the password
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Jan 03 2022 03:25 AM
Jan 03 2022 03:31 AM
Please read my link ... to be able to send an answer that suits you.
Welcome to your Excel discussion space!
Thank you for your understanding and time
I know I don't know anything (Socrates)
Jul 21 2022 12:02 PM - last edited on Nov 09 2023 11:19 AM by
@ohmnamoh I was wondering if you got a proper answer/solution yet? I have the same issue and it is annoying for sure.