| 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 | |||
![Jim[_80_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
