0

Is there any method/practice where I can put my code during a Workbook opening (a sort of a constructor method)?

I need to do some stuff before the user is ready to see all sheets

Improve this question
2
  • You mean something like the Workbook_Open() event? Commented May 3, 2016 at 10:14
  • Yes, it is called the Workbook.Open event and is documented in the VBA documentation. Commented May 3, 2016 at 10:14

2 Answers 2

Reset to default
2

I dont know how to that during the opening but I know that there is a method which is workbook_open. And if you put Application.ScreenUpdating = False statement on top of your code, you get pretty much what you want.

Private Sub Workbook_Open() Application.ScreenUpdating = False 'Some codes here End Sub
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

2 
Private Sub Workbook_Open() Msgbox "Welcome to ANALYSIS TABS" End Sub

http://analysistabs.com/excel-vba/run-macro-automatically-opening-workbook/

Improve this answer

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.