Ms access vba turn off screenupdating

Rated 4.50/5 based on 883 customer reviews

The one worksheet is a splash screen that says something to the effect of "You're not going to see anything until you enable macros".

ms access vba turn off screenupdating-75

ms access vba turn off screenupdating-36

ms access vba turn off screenupdating-59

ms access vba turn off screenupdating-53

Visible = xl Sheet Visible 'Make the Splash screen worksheet visible For Each ws In This Workbook. Protect Password:=pswd 'Protect the workbook before saving it This Workbook. Visible = xl Sheet Visible 'Make all sheets except Splash screen visible Next wsws Splash. Avoids recursive calling of events subswb Closing = False 'Initialize wb Closing to False Set ws Splash = Worksheets("Splash screen") 'Pointer to the Splash screen worksheet This Workbook. Visible = xl Sheet Visible 'Make worksheets visible Next wsws Splash.

---------------------------------------Neil This request is related to the general problem of forcing users to enable macros.

John Walkenbach suggests one way at basically make all the worksheets but one xl Very Hidden.

Visible = xl Sheet Visible For Each ws In This Workbook. I have added a password to my workbook via save as Can't you just have an Excel open password? You set a password to open on the Save As/Tools/General Options box. My grandfather was ill, and my grandmother smeared goose-grease on his back. Glenn: Yea recently added that password to my workbook, works great just havent got a different sheet to pop up if someone doesnt enable macros. The setup i have is: User opens workbook: enters the password to get in.

All sheets are hidden and protected apart from the first 'Menu' sheet.

Leave a Reply