Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening workbooks and stopping the messages
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening workbooks and stopping the messages
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, 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
stopping a window for opening | Excel Programming | |||
Stopping "Query Refresh" messages | Excel Discussion (Misc queries) | |||
Stopping "Query Refresh" messages | Excel Discussion (Misc queries) | |||
Solution to stopping IE opening excel workbooks without changing windows settings | Excel Discussion (Misc queries) | |||
Stopping error messages from popping up - part 2 | Excel Programming |