using filename or a cell value for a custom menu

  • Thread starter Thread starter Solutions Manager
  • Start date Start date
S

Solutions Manager

Long story short. I created a workbook with a custom menu that loads/unloads
when the sheet opens. This works great, except when two copies of the
worksheet are open. This happens because the sheet is a template. Doing an
AddIn, using XlStart or Personal Workbook really aren't great options, so
here is the question.
Rather than having the custom menu have a fixed name such as "My Menu", can
the custom menu name be a variable based on either a cell value or the
workbook name itself? this would solve the problem as each workbook would
create a custom menu rather than unloading/loading a menu with the same name.
Suggestions anyone?
 
I may have answered my own question this time. I just replaced the menu
caption with the value from a specific cell.
 
Back
Top