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?
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?