I'm not sure if I'm stating this correctly, so bare with me.
I'm creating a custom toolbar where the user can create their on view of the worksheet. I've created much of the code and I'm stumped on how to get the name of the menuitem (commandbar button) the user selected, so I know which sheet to look at (the first step is for the user to create how they would like their sheet to look, then it creates a button with the name the user wanted to call it, saves a sheet in the add-in with that same name. So, when they select the custom button they created it would go to the sheet in the add-in)
Any thoughts on how to get the name of the toolbar button the user selected?
I appreciate any help. Thx
I'm creating a custom toolbar where the user can create their on view of the worksheet. I've created much of the code and I'm stumped on how to get the name of the menuitem (commandbar button) the user selected, so I know which sheet to look at (the first step is for the user to create how they would like their sheet to look, then it creates a button with the name the user wanted to call it, saves a sheet in the add-in with that same name. So, when they select the custom button they created it would go to the sheet in the add-in)
Any thoughts on how to get the name of the toolbar button the user selected?
I appreciate any help. Thx