Excel Splash Screen - Display with a Macro on Opening a File
Learn how to display a splash screen over the top of an Excel file on opening the file. This screen is created using a custom form that I will step you through creating. The macro uses the special Auto_Open event in Excel to run on opening a file. The user can opt to hide the screen for the future but this can be reversed. This macro solution is full of handy information relating to creating forms and keeping track of user settings using a simple text file.
This code goes behind the form:
Private Sub CommandButton1_Click()
If CheckBox1.Value Then
Open CreateObject("WScript.Shell").SpecialFolders("MyDocuments") & "\Productsplashscreendisabled.txt" For Output As #1
Close #1
End If
Sheets("Help").Select
Unload Me
End Sub
Private Sub CommandButton2_Click()
If CheckBox1.Value Then
Open CreateObject("WScript.Shell").SpecialFolders("MyDocuments") & "\Productsplashscreendisabled.txt" For Output As #1
Close #1
End If
Sheets("Sheet1").Select
Unload Me
End Sub
Private Sub UserForm_Initialize()
Me.Top = Application.Top + (Application.UsableHeight / 2) - (Me.Height / 2)
Me.Left = Application.Left + (Application.UsableWidth / 2) - (Me.Width / 2)
End Sub
This code goes in a module in your file:
Sub auto_open()
If Dir(CreateObject("WScript.Shell").SpecialFolders("MyDocuments") & "\Productsplashscreendisabled.txt") = "" Then
UserForm1.Show
End If
End Sub
This is the code for the two button_click events:
Sub Button1_Click()
On Error Resume Next
Kill CreateObject("WScript.Shell").SpecialFolders("MyDocuments") & "\Productsplashscreendisabled.txt"
End Sub
Sub Button2_Click()
UserForm1.Show
End Sub
VIEW MORE VIDEOS JUST LIKE THIS ON MY KZitem CHANNEL
Microsoft Office ► / @mastermicrosoftoffice
TIP ME TO SAY THANK YOU? ► paypal.me/projectwoman
VISIT PROJECTWOMAN.COM FOR MORE ON MICROSOFT OFFICE APPLICATIONS:
Website ► www.projectwoma...
Blog ► www.projectwoma...
LET'S CONNECT!
Facebook ► / projectwoman
Twitter ► / helenbradley
LinkedIn ► / helenbradley
IF YOU LIKED THIS VIDEO YOU MAY LIKE THESE SIMILAR VIDEOS:
Microsoft Excel Mac - Remove Custom Templates ► • Excel Mac - Remove Te...
Microsoft Word - Images in Tables - How to place & position pictures in Word Tables ► • Word - Images in Table...
Microsoft Word - Change Default Image Wrap ► • Word - Change Image De...
Microsoft Excel - Custom Lists and Sort lists ► • Excel - Custom Lists a...
Microsoft Excel - Count days between two dates ► • Excel - Count days bet...
Microsoft Word - Table Cell Widths - Adjust one or more with ease ► • Microsoft Word - Table...
A Microsoft Word Macro to Resize All Images in a document • A Word Macro to Resize...
Microsoft Excel - Format a List Instantly - Quick & Easy Table Formatting Trick for Lists ► • Insanely Simple Excel ...
Office Tab for Word Excel and PowerPoint - A quick look at this handy application ► • Office Tab for Word Ex...
Microsoft Excel - Hide Unused Rows and Columns - Show only used cells ► • Excel - Hide Unused Ro...
Microsoft Excel - Click to Enter Data - Create Custom Spin Buttons ► • Excel - Click to Enter...
Excel - Save to Computer not OneDrive - Change the Excel default Save location ► • Excel - Save to Comput...
Excel - Personal Macro Workbook - what it is and how to create and use it ► • Excel - Personal Macro...
Excel - File Save Macro - A Smart Macro to Manage Saving Files Better ► • Excel - File Save Macr...
Excel - Charts that Don't Lie - Configure Sparklines to be Useful ► • Excel - Charts that Do...
Word Calendar Wizard - Get the original Calendar Wizard to work in 2023 ► • Word Calendar Wizard -...
Excel Goal Seek - Find Answers Quickly & Easily ► • Excel Goal Seek - Find...
Excel Chart for B & W Print & Photocopying - Grayscale Chart Formatting ► • Excel Chart for B & W ...
Excel - Chart With 2 Axes - Add a 2nd Axis to a Chart & Control the Data Shown ► • Excel - Chart With 2 A...
Excel Data With ChatGPT - Create Data for Practice - for Teachers & Trainers► • Excel Data With ChatGP...
Excel - VBA File Open Macro - Make & Add to Ribbon for One Click Access► • Excel - VBA File Open ...
Excel - Macro to Shade Alternate Rows in a Selection► • Excel - Macro to Shade...
Excel - Conditional Format Shade Alternate Rows - Create a Quick & Easy Format► • Unbelievable Excel Sec...
Excel NETWORKDAYS.INTL: Unlock the Secrets to Accurate Workday Count► • Excel - Count Workdays...
Save Time in Excel: Quick Math Operations with Copy-Paste - Apply Math Operation to all Data► • Save Time in Excel: Qu...
Word 365 - 4 Rotate Text Methods - Angled Vertical & Flipped ► • MS Word - Rotate Text ...
#helenbradley #microsoftexcel #microsoftoffice #projectwoman #ExcelVBA #ExcelMacro
Негізгі бет Excel Splash Screen Macro - Display on Opening a File
Пікірлер: 4