I have 4 Excel applications that analyze different data from a
project/schedule. I want to create a "wrapper" workbook that shows a
user form with 4 buttons that will launch each of the various
workbooks.

Problem - each has different set of macros (some with the same name but
different funcationality) and different user menus. How can I control
the macros and menus if the user opens more than one workbook?

Potentially, the user could have all 4 workbooks open. I want only the
menu appropriate to the active workbook to show. Also I want only the
macros from the active workbook to be available for use.

How can I do that?


Glen

You'll make your life much simpler if you change those macro names to nice
unique names.

And you could use the workbook_activate and workbook_deactivate to show/hide the
menus you want.

wrote:

I have 4 Excel applications that analyze different data from a
project/schedule. I want to create a "wrapper" workbook that shows a
user form with 4 buttons that will launch each of the various
workbooks.

Problem - each has different set of macros (some with the same name but
different funcationality) and different user menus. How can I control
the macros and menus if the user opens more than one workbook?

Potentially, the user could have all 4 workbooks open. I want only the
menu appropriate to the active workbook to show. Also I want only the
macros from the active workbook to be available for use.

How can I do that?

Glen

--

Dave Peterson