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!

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

Disable update macro?

Status
Not open for further replies.
kev777

kev777

Technical User
Nov 18, 2001
9
GB
I have a VB app that opens a xl sheet that contains linked fields via DDE so upon opening I have to click YES to update the fields. Is there any code I can use so the sheet automatically updates?

Many Thanks,

Kev.
 
Sort by date Sort by votes
Just a SWAG...
[tt]
Application.DisplayAlerts = False
[/tt]
in your Workbook_Open might help.

Don't count on it though.

Wil Mead
wmead@optonline.net

 
Upvote 0 Downvote
Thank you, but will this automatically update the links or do I have to use any more code?

...sorry...newbie!
 
Upvote 0 Downvote
If it works, it submits the default response to the alert.

Wil Mead
wmead@optonline.net

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

44MARCO
  • Locked
  • Question
MACRO SETTINGS - VBA PROJECT OBJECT MODEL 1
Replies
2
Views
379
strongm
strongm
sal21
  • Locked
  • Question
UPDATE DAO RECORDSET 1
Replies
11
Views
415
strongm
strongm
Rod41
  • Locked
  • Question
How to disable/enable a selected cell in a DataGRid view
Replies
1
Views
227
jebenson
jebenson
kskinne
  • Locked
  • Question
help with code used to update multiple records from datagrid 1
2
Replies
33
Views
661
Andrzejek
Andrzejek
VicM
  • Locked
  • Question
How to suppress Update query msg when run in VBA
Replies
2
Views
100
VicM
VicM

Part and Inventory Search

Sponsor

Back
Top