Opening workbooks and stopping the messages

J

Jim

I have a set of spreadsheets that do wonderful things.
As they go about their business, values in them get updated and these values
are reflected in other workbooks.

Unfortuneatly when I update - in VBA - the initial spreadsheet, I then get
the message about updating the second workbook and also a message about bad
links. At that time the second workbook is not open and I dont really want
to.

I want to prevent these messages. Any ideas.



Jim Crawford
81 The Phelps
Kidlington
OX5 1TL

01865 377437
 
I

isabelle

hi Jim,

have you tried with
Application.DisplayAlerts = False

--
isabelle


Le 2011-12-08 11:54, Jim a écrit :
I have a set of spreadsheets that do wonderful things.
As they go about their business, values in them get updated and these values are reflected in other workbooks.

Unfortuneatly when I update - in VBA - the initial spreadsheet,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top