- I have a Workbook 'A' that contains a macro, which places data into Workbook 'B'.
(Note that both Workbooks are loaded in Excel).
- B contains code in it's 'BeforeSave' event, which protects the sheets before it is saved.
- The last command of the macro in A, saves B. So, the 'BeforeSave' event is invoked.
- However, Excel happily runs the code in the 'BeforeSave' but doesn't actually perform the commands! The result is no protected sheets in B.
The 'BeforeSave' event code works fine on its own, but doesn't seem to work when invoked by another macro??
Note: I am using Excel 2000 with all the latest patches installed.
Please could anyone help.
Many thanks,
Jason
This message was edited by jasonking on 2002-04-25 08:24
(Note that both Workbooks are loaded in Excel).
- B contains code in it's 'BeforeSave' event, which protects the sheets before it is saved.
- The last command of the macro in A, saves B. So, the 'BeforeSave' event is invoked.
- However, Excel happily runs the code in the 'BeforeSave' but doesn't actually perform the commands! The result is no protected sheets in B.
The 'BeforeSave' event code works fine on its own, but doesn't seem to work when invoked by another macro??
Note: I am using Excel 2000 with all the latest patches installed.
Please could anyone help.
Many thanks,
Jason
This message was edited by jasonking on 2002-04-25 08:24