Why do some sub commands work on workbook open, yet some do not?
for example:
Private Sub workbook_open()
ActiveWindow.DisplayHeadings = False
Application.AskToUpdateLinks = False
End Sub
The headings turn off, but other users still get the message :
"Do you want to update links?"
Can somebody please help??
I need to understand how the sub is called. Is it when it is enabled by a macro, or on a true file open (from a drive location for example)
for example:
Private Sub workbook_open()
ActiveWindow.DisplayHeadings = False
Application.AskToUpdateLinks = False
End Sub
The headings turn off, but other users still get the message :
"Do you want to update links?"
Can somebody please help??
I need to understand how the sub is called. Is it when it is enabled by a macro, or on a true file open (from a drive location for example)