Run macro automatically upon opening or closing document

  • Thread starter Thread starter Munchkin
  • Start date Start date
M

Munchkin

How do I automatically run this macro when the workseet is either opened or
closed?


Rows("2:3").Select
Range("B2").Activate
Selection.EntireRow.Hidden = True
Rows("6:7").Select
Range("B6").Activate
Selection.EntireRow.Hidden = True
Range("C12").Select
End Sub
 
You have a problem with your on close. The changes are going to require the
file to be saved. That being said since the code is being run on open the on
close is not necessary. I would be inclined to just do this...

Private Sub Workbook_Open()
With Sheets("Sheet1") 'Change to the appropriate sheet name
.Rows("2:3").EntireRow.Hidden = True
.Rows("6:7").EntireRow.Hidden = True
.select
.Range("C12").Select
End with
End Sub

Right click the XL icon in the upper left corner of the Excel window and
select View Code. This takes you into the ThisWorkbook module. Post the code
above.
 
Back
Top