how do i have a cell number increase by 1 each time file opened
i would like to know how to formulat a cell so each time the number in the
cell will increase by 1 or 5. there will be 5 people who access this file only one at a time. |
how do i have a cell number increase by 1 each time file opened
Cannot be done through formatting.
Need code to run when opening the workbook. Private Sub Workbook_Open() With Sheets("Sheet1").Range("A1") ..Value = .Value + 1 End With End Sub Right-click on the Excel Icon left of "File" and select "View Code". Copy/paaste the above into that module. Alt + q to return to the Excel window. Make sure there is a number in the cell. Save, close and re-open to see the number increase by 1 Gord Dibben MS Excel MVP On Sat, 24 May 2008 17:52:00 -0700, DJbase wrote: i would like to know how to formulat a cell so each time the number in the cell will increase by 1 or 5. there will be 5 people who access this file only one at a time. |
All times are GMT +1. The time now is 07:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com