Blur the background when starting Excel

zelarra

New Member
Joined
Jan 2, 2021
Messages
9
Office Version
  1. 2016
Platform
  1. Windows
Hello. I have created a form to ask for the password when the excel file is started. Until now, it worked perfectly with Office 2016, but when I switched to Office 2019, sometimes the sheet appears, and, therefore, its content, which I don't want to be seen, and sometimes not. You can see what it does in the attached image.

ScreenShot001.jpg.30285c4187d2aff2f9943e0bc7ea3efc.jpg

I don't know why sometimes he does it well and other times he doesn't. I also don't know if there is a possibility to blur the background using VBA.

I also enclose the Excel so that you can work with it. The password is 1234.


Thank you.
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

sxhall

Board Regular
Joined
Jan 5, 2005
Messages
146
zelarra,

Low key option could you add in a blank sheet to default to when the workbook is opened? On save or closing a macro could run selecting this sheet so it is the default for next time the workbook is opened.

Once the password is entered user can navigate to the required sheet.

Steven
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
20,585
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
The file you uploaded appears to have been deleted.
 

zelarra

New Member
Joined
Jan 2, 2021
Messages
9
Office Version
  1. 2016
Platform
  1. Windows
OK thank you. I had thought about that solution, but I wanted to know if there was another possibility or I was doing it wrong, so I shared the file, but seeing that I did not get a response, and since it needed space, I deleted it.
 

HaHoBe

Active Member
Joined
Jan 24, 2003
Messages
480
Office Version
  1. 2013
Platform
  1. Windows
Hi zelarra,

maybe activate the last cell at the bottom right of the worksheet before asking for the password and going to the data range if it was succeefull otherwise switch to another sheet or close the workbook?

Ciao,
Holger
 

Forum statistics

Threads
1,137,125
Messages
5,679,755
Members
419,855
Latest member
Eddier32

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
Top