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 |
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 |
All times are GMT +1. The time now is 06:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com