Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel file opened automaticaly at specified time & date | Excel Discussion (Misc queries) | |||
Number in cell increase with increase in font size. | Excel Discussion (Misc queries) | |||
how do i increase invoice number everytime its opened? | Excel Discussion (Misc queries) | |||
How to automtically increase a number every time a file is used | Excel Discussion (Misc queries) | |||
auto insert invoice number that increases by one each time opened | Excel Worksheet Functions |