Excel 2007 formula calculation
Assuming a "slidebar" is a scroll bar I don't see any change in behavior
between Excel 2003 and 2007. When a scroll bar from either the Forms or
Control Toolbar toolbars is used (you didn't say which you were using) and a
linked cell changes value, the sheet_change event is not fired. I assume
you're using the sheet change event. But the scroll bar change event is
fired for a Control Toolbox scroll bar. And a macro attached to a Forms
toolbar scroll bar would also fire and it could calc the sheet.
--
Jim
"joeeng" wrote in message
...
| have ported great deal of vba code from Excel 2003 to Excel 2007. I am
| happy to say that most things worked, even things I thought would not.
| However, one issue has stumped me. I have some worksheets that have
| slidebars to change some values which in turn feed into the lookup_value
and
| reference for Hlookup, Vlookup, and Offset functions, respectively.
However,
| with autocalculation set to manual, Vlookup, Hlookup, and Offset functions
| are not recalculating when a me.calculate is issued via vba code in the
| worksheet module. This code works perfectly in Excel 2003. Does anyone
know
| why these worksheet functions are not updating and what can be done to
make
| them work in Excel 2007?
|