Worksheet event code

[Peter Muller]

Hello Excel Experts,

I run macro’s from a Drop Down list. I have 20 macro’s in the list.

• These macro’s run from a worksheet event code. Is it at all possible to group the macros into sub categories in the drop down list, similar to a dependent drop down list, within the worksheet event code? This then allows me to select the category, which opens another view window, from which I select the macro, and it then runs immediately?
• 
  
• Is it possible to increase the size of the view window when I click on the drop down arrow so that I do not have to scroll down and look for the macro I want to run?

Thank you

 

[Peter Muller]

Yes, as explained in #6

My initial posting in #1 had the query you responded to, and the one Yongle and Caleeco responded to