what is this object called? - right hand corner of statusbar
That threw an error in Excel 97.
--
Regards,
Tom Ogilvy
"Greg Wilson" wrote in message
...
The following will call the menu if it's of any use:
Application.CommandBars(49).ShowPopup
Regards,
Greg
-----Original Message-----
In the bottom right hand corner of the status bar (right
click). A user has
the ability to either Average, Count, Count Nums, Max,
Min or Sum the
contents of the highlighted range. I want to be able to
call that procedure
using an OnKey Method to copy that value to the
clipboard. Then the user
could paste that value elsewhere in excel.
.
|