Updating Calculations
Possibly
Application.CalculateFullRebuild
or
Application.CalculateFull
Your a little vauge about what triggers your macros. If it is a
workbook_activate event then
You might need to do
for each bk in Workbooks
if lcase(bk.Name) < "summary.xls" then
bk.Activate
Activesheet.Range("A1").Select
end if
next
workbooks("Summary.xls").Select
--
regards,
Tom Ogilvy
"Fred Ernst" wrote:
I'm using a Workbook that has macros in it for updating Charts when input
and calculations change. I do not have access to the code for the Workbook.
I have multiple instances with different filenames of this Workbook open in
tile mode, with links in both directions to another "Summary" Workbook.
The instances of the Workbook with the Chart macros won't update until I
click individually on them. So I need to click on each one of them to update
the "Summary" Workbook properly.
Is there a procedure I can use to recalculate all of the instances of the
Workbooks with the Chart macros at the same time?
Thanks,
Fred
|