LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default No 'Click' for CommandBarPopups, so what should I do?

I would like to have a custom menu (CommandBarPopup) to have it's items
enabled/disabled depending on the current user selection (e.g. chart/cell).

The problem I'm facing now is that there is no Click property attached to
the CommandBarPopup class. I am aware of the OnAction property which can be
used to call VBA code, but what is the best way to approach this?

This is for a COM Add-in, not for a single workbook and all the examples
I've seen of using VBA are bound to a single file.

The rest of my Add-in is written in C#.

I was considering having a placeholding CommandBarButton that, when Clicked,
would execute the required code, before making itself invisible and making
the true CommandBarPopup menu visible.

However, this solution is for blind users, who would be accessing the menu
via keyboard shortcuts and having the contents read out by a screen reader.
If the menu item originally selected is not the CommandBarPopup, I don't know
how this would confuse the screen readers/users mental model of what is going
on.

So, in short, how does one invoke a method upon the clicking of a
CommandBarPopup?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disabling click and right-click on the Picture I inserted in an Excel document [email protected] Excel Worksheet Functions 1 June 2nd 06 09:13 PM
userform label double-click goes to click event John Paul Fullerton Excel Programming 3 May 19th 06 05:54 PM
Scrollbar single click acts like click and hold Ken Shaffer Excel Programming 0 December 5th 05 07:06 PM
Click on graph bar to execute a double-click in a pivot table cell [email protected] Charts and Charting in Excel 4 August 3rd 05 01:37 AM
Mouse Over Graph, Capture Information on Click(Double Click) Dean Hinson[_3_] Excel Programming 1 December 6th 04 04:49 AM


All times are GMT +1. The time now is 01:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"