Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a two workbooks which are linked together. One field in the master
workbook has a TRUE/FALSE field. Through a link to a similar field on the slave workbook, it controls which set of values are being used. The values are either Financed or NonFinanced. When I run a macro to print either set of values, the macro sets the value in the master to either TRUE or FALSE. Then it prints. The print always seems to be one behind - that even though the valuie was set to TRUE by the macro, the calculated values are for the FALSE setting. And vice-versa if the macro sets it to false - it prints the TRUE version. If you run it the second time - without resetting the TRUE/FALSE, it's fine. I've tried applying Application.Volatile TRUE but it doesn't seeem to be helping. What else can I do to get the workbooks in synch? -- DRK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Forcing to recalculate | Excel Worksheet Functions | |||
Forcing to Uppercase | Excel Discussion (Misc queries) | |||
forcing UDF to run | Excel Worksheet Functions | |||
Forcing an input in a pop up box | Excel Programming | |||
Forcing users | Excel Programming |