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