Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

display alerts not working properly? Excel 2002 1

Status
Not open for further replies.

christhedonstar

Programmer
Apr 9, 2007
215
GB
Hi,

When I do

Application.EnableEvents = False
Application.DisplayAlerts = False

Workbooks.Open theworkbook.xls

I get a notification asking if I I want to update links. I don't understand why I get asked this question when displayalerts is false...

Any ideas?

Thanks,

Chris
 
I you want to update links:
Workbooks.Open theworkbook.xls, True

I you want to NOT update links:
Workbooks.Open theworkbook.xls, False

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
ooops I managed to skip the first argument and look through all the others!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top