Alt F11 Secure Window

Ivan Howard

Active Member
Joined
Nov 10, 2004
Messages
332
Hi All,

Does anyone know if there is a way to get the database window back after locking it out on the 'Startup' screen?

I unchecked the "Use Access Special Keys" option and couldn't get it back. Luckily I had made a copy so no harm done, but I would like to restrict this function in the database for when I roll it out... BUT I do want to be able to get it back without too much of a problem.


I have decided to not use the built in security, so I need another method. Is there a VBA option that I could use to show the window?

Many thanks.
 

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.

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
6,889
Office Version
  1. 365
Platform
  1. Windows
Try holding down the shift key and the enter key simoultaneously to open the data base.

Alan
 

Ivan Howard

Active Member
Joined
Nov 10, 2004
Messages
332
Re: F11 Secure Window

Apologies as this should not have been ALT+F11, but rather F11 only.

Thanks Alan, but I cant get this to work.

On the "Startup" dialog box, I have deselected the following boxes:
"Display Database Window"
"Use Access Special Keys"

But when I go to "Window" at the top, I can unhide the database window.

I have also tried deselecting the following, (as well as the two at the top):
"Allow Full Menus"
"Allow Default Shortcut Menus"
"Allow Built-in Toolbars"
"Allow Toolbar/Menu Changes"

But when I do this, exit the database and then open it again, no matter what I do, I cannot get the database window open again. :(
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,982
Messages
5,834,698
Members
430,310
Latest member
Excelorate3305

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