View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheetfunctions,microsoft.public.excel.programming
[email protected] meghantrus@hotmail.com is offline
external usenet poster
 
Posts: 10
Default How do I auto run my macro upon open of file....Workbook_Open() is NOT working?

I need to run a Macro named UpdateData upon open of the file.
This code is not working. I placed the below code in ThisWorkbook.
I am able to manually run UpdateData, but it does not run
automatically when I open the file.
Security is set to Medium and I enable Macro's when I open the file.
What am I doing wrong?


Private Sub Workbook_Open()
Call UpdateData
End Sub