Frank Kabel wrote...
...
thanks for this specific error explanation. But looking at the code I
would suspect
that it is not this code part but the resetting of the
application.calculate mode to
automatic. Just executing the two statements

application.calculate=xlCalculationManual
application.calculate=xlCalculationAutomatic

will re-calculate volatile functions.

Perhaps they do, but do you think I don't know what I'm talking about?
Start off with a new workbook, for good measure, UNINSTALL CF Plus,
enter =RAND() in A1, then format B1 with a red background, copy B1 and
paste special as format onto A1. What happens to the value in cell A1?

So, you just didn't want to test my assertion?

Next, either the copy or paste format function doesn't work. If I
select the A1 cell formatted as above, run the menu command

Yes, a bug. Wrong check procedure at the beginning due to a last
minute
change. will work in the next update. Thanks for that spot. We will
also add a
note that for complicated conditions copying these format copying may
not work
(esp. if you're using relative references in the condition)
...

So you broke a different fundamental programming rule: NEVER, repeat
NEVER! make last minute changes before releasing any code. The odds are
phenominally high you'll screw things up. I'll let you figure out the
corrollaries with respect to feature locks.

The 'garbage' is due to using a shape to indicate the used CF cells.
This feature
is only a 'nice to have' to show which cells have a CF applied.

OK, suggestion for long-term feature change: make it an optional
setting how to

No, what's annoying about this is that if I select some
other cell then click on A1, the dialog appears again, but after
dismissing the dialog the cell pointer is returned to it's starting
point rather than staying in cell A1. On the other hand, if I use
cursor keys to return the cell pointer to A1, I don't get the dialog
and I stay in cell A1. Maybe this is specific to XL97, but REALLY
ANNOYING that *clicking* on cell A1 won't leave the cell pointer at
A1.

Works as designed :-) and also the reason why the cursor keys don't
trigger the
message box is also due to using the shape object But still valid
points from
your side and depending on other feedback we may change this
behaviour
...

Or make it optional.


--
hgrove
------------------------------------------------------------------------
hgrove's Profile: http://www.excelforum.com/member.php...o&userid=11432
View this thread: http://www.excelforum.com/showthread...hreadid=276025