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

Related posts about microsoft-excel

Related posts about microsoft-excel-2010