how do i count everytime a spreadsheet is opened

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Within microsoft excel, I need to show a counter that will increase everytime
that file is opened.
 
The following will put a counter in Sheet1 cell A1. Paste the macro in
Workbook code:


Private Sub Workbook_Open()
Set r = Sheets("Sheet1").Range("A1")
r.Value = r.Value + 1
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to increase counter every time open excel 1
exel old software/new computer 3
Using a template form, advance a form number everytime you open 1
printing on excel 1
Don't Update Function 1
Opening Excel 1
Hide toolbars/Workbook elements 2
Spreadsheet keeps duplicating drawn lines. 2

Back
Top