Run A Macro When Worksheet Opens Excel

In the VBA editor, put the following code in the "This Workbook" sheet:


Private Sub Workbook_Open()
MsgBox "I just opened my workbook"
End Sub

then save the workbook, close it, and open it again to see if this is what you want.

Comments

Popular posts from this blog

C# Crop white space from around the image

Could not load file or assembly 'Microsoft.ReportViewer.Common, Version=xx.0.0.0, Culture=neutral, PublicKeyToken='xxx' or one of its dependencies.

The specified version string contains wildcards, which are not compatible with determinism.