Incorrect password input opens new blank workbook

Mazbuka

New Member
Joined
Sep 23, 2018
Messages
23
Office Version
  1. 365
Platform
  1. Windows
Hi,

Very small issue but it annoys me...if I type a password in correctly, a new book opens, which I then have to close.

I can't see anywhere in options to disable this...can it be (disabled)?
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
A pretty vague thread !!!
Password for what ??.....Sheet, Workbook ?
Is it an Input box created by code or a native password input box ???
Is there code in the workbook ??

You really need to provide more information.....remember, we can't see what is happening on your computer !!!
 
Upvote 0
Sorry...workbook that's password protected ie needs a password to open it.

If I input this incorrectly, the workbook won't open, as is to be expected, but a blank workbook opens, this used not happen before...no code in the workbook.

Hope that's clearer
 
Upvote 0
Sorry, I was away for a bit.

No joy with the suggestions in the link, thanks for your efforts.

I'm on a PC, not large files eg I open a new blank workbook, save it as "test" , then File-->Protect workbook--->Encrypt with a password

If I create the password 123, save & close. then I open it, type in password 124, I get the incorrect password message & instead a new Book1 opens.

This is a relatively recent development, though it might be something new with a recent upgrade but internet searches don't show anything....anyway, it's just a minor irritant.
 
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,291
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top