Autoexecution of a Macro
I have created a macro that performs computations of
fields across several workbooks. How do I get this to automatically execute every time the workbook perform the auto-calculation function? Thanks. |
Autoexecution of a Macro
Put the code in the calculate event at the workbook level. Or call the code
from the calculate event at the workbook level. -- Regards, Tom Ogilvy "Dale Cox" wrote in message ... I have created a macro that performs computations of fields across several workbooks. How do I get this to automatically execute every time the workbook perform the auto-calculation function? Thanks. |
All times are GMT +1. The time now is 11:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com