Skip to Content
0
Former Member
Jul 03, 2009 at 09:10 AM

Custom Menu with CV Override

36 Views

Dear All,

We are using custom menus, and the CV override option to set time and category when the menu is opened.

I have found that when opening a custom menu, although the CV is changed, the AFTER_CHANGECVW event does not get fired.

I need to run some VBA code which retrieves the current view settings and then configures the menu, but I can not find an event that I can use to do this when the menu is opened.

I have tied adding a application.wait to the Workbook_Activate event, but this just delays the whole process, and has no effect.

Any suggestions would be appreciated.

Regards,

Mark