still learning
Well-known Member
- Joined
- Jan 15, 2010
- Messages
- 774
- Office Version
- 365
- Platform
- Windows
Hi
I'm have a brain freeze or a senor moment
I have a workbook with one sheet in it.
When I open the workbook, I want a macro (opene) to trigger
I put this in sheet1 and nothing (
I tried to change open to activate and still nothing
I used F8 to make sure the macro works
I tried to put
private sub workbook_ open, then _activate in "this workbook" and still nothing leaving the code in the sheet1
mike
I
I'm have a brain freeze or a senor moment
I have a workbook with one sheet in it.
When I open the workbook, I want a macro (opene) to trigger
I put this in sheet1 and nothing (
VBA Code:
Private Sub WorkSHEET_open()
opene
End Sub
I used F8 to make sure the macro works
I tried to put
private sub workbook_ open, then _activate in "this workbook" and still nothing leaving the code in the sheet1
mike
I