View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.


.