johnphilips
New Member
- Joined
- Jan 22, 2013
- Messages
- 11
Hi all
I have been suching the net for a VBA code. I have been looking for days and i have found nothing.
I'm working on a workingsheet that need to save before closing with the name reading from 2 cells. Either im Stupid or I haven't found a code for it. I have just start to learn all this. Pleas help me.
In one of the cells is a number and I have put in a macro. So evertime it opens it adds +1. Here the Marco i added:
Private Sub Workbook_Open()
Range("F1") = Range("F1") + 1
ActiveWorkbook.save
End Sub
Can anyone help me?![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Regards john
I have been suching the net for a VBA code. I have been looking for days and i have found nothing.
I'm working on a workingsheet that need to save before closing with the name reading from 2 cells. Either im Stupid or I haven't found a code for it. I have just start to learn all this. Pleas help me.
In one of the cells is a number and I have put in a macro. So evertime it opens it adds +1. Here the Marco i added:
Private Sub Workbook_Open()
Range("F1") = Range("F1") + 1
ActiveWorkbook.save
End Sub
Can anyone help me?
Regards john