Excel 2010 VBA on-start macro execution - Error
Posted
by
Noob Doob
on Super User
See other posts from Super User
or by Noob Doob
Published on 2013-10-30T13:47:18Z
Indexed on
2013/10/30
15:58 UTC
Read the original article
Hit count: 226
I have been trying to create a macro to be executed every time I open the document. I tried to use the Open event, but it does not seem to be working. The code is below:
Private Sub Workbook_Open()
Cells(3, 1) = "WOWWW"
End Sub
(It might seem ridiculous but I am trying to make any chunk of code to work, to move further with the start-time macro).
Each time I open the file, the cell (A3
) does not seem to be changing. Any ideas on this?
I don't know if it matters, but I don't open the file directly. I open it through opening the Excel program and then File Tab
-> Open
-> File
. That is because I have a problem if I open the file directly, which is another matter.
© Super User or respective owner