how do i count everytime a spreadsheet is opened

N

nipper

Within microsoft excel, I need to show a counter that will increase everytime
that file is opened.
 
G

Gary''s Student

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
 

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

Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
How do I link a cell in a workbook? 1
Need Help with Macro Security 1
How to automate update on weekly reports spreadsheet 0
how to increase counter every time open excel 1
Excel Opens Multiple personal.xls 0
How to count the numbers in a Word document? 0
Need VBA Macro to Loop through pages and print counter in footer of each page 9

Top