View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
kevindmorgan
 
Posts: n/a
Default incrementing account numbers


To enable macros:

ToolsMacroSecurity

In Security Level Tab, set to Medium.

For the second cell. Just add the other cell in the macro:

Sub Auto_Open()
Sheets("whicheversheet").select
Cells(1, 5).Value = Cells(1, 5).Value + 1
Cells(19, 5).Value = Cells(19, 5).Value + 1
End Sub


--
kevindmorgan
------------------------------------------------------------------------
kevindmorgan's Profile: http://www.excelforum.com/member.php...o&userid=32232
View this thread: http://www.excelforum.com/showthread...hreadid=520795