I think either Call UpdateData or Run "UpdateData" should work. Make
sure the Workbook_Open code is attached to the ThisWorkbook object,
and not in a regular module.

Good luck.

Ken
Norfolk, Va


On Jun 1, 10:54 am, Mike wrote:
Try this
Run "UpdateData"



" wrote:
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- Hide quoted text -

- Show quoted text -