# Count Number of Times worksheet has been Open

#### Peterleee

##### Board Regular
is there any way to programatically add 1 to a counter whenever a worksheet/ workbook is open? and explain the process

thanks

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

#### TryingToLearn

##### Well-known Member
For workbook OPENS:

Code placed in ThisWorkbook module

Code:
``````Private Sub Workbook_Open()
Sheets("sheet1").Range("a1") = Sheets("sheet1").Range("a1") + 1
End Sub``````

For worksheet ACTIVATES:

code placed in the Sheet module

Code:
``````Private Sub Worksheet_Activate()
me.Range("a1") = me.Range("a1") + 1
End Sub``````

HTH

#### Colo

##### MrExcel MVP,
Hello Peterleee,

Plase the number into the specific cell, and add number when workbook is opened with useing Workbook_Open Event.

Code:
``````'Place this in the ThisWorkbook module
Private Sub Workbook_Open()
Sheets("Sheet1").Range("A1").Value = Sheets("Sheet1").Range("A1").Value + 1
End Sub``````

Replies
4
Views
161
Replies
1
Views
106
Replies
0
Views
600
Replies
1
Views
170
Replies
2
Views
142

1,187,187
Messages
5,962,101
Members
438,583
Latest member
DJTCharts

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back