What I meant was that there are various excel books ( workbooks) with
macros in it. There are also menu individually in them.

However, we extract data from other software roughly every 15 days and each
work books has macro that pulls the data and analyse them.

Instead of depending on end user to click the menu button on each workbook.

We in our department would like a word document or excel document that has
buttons which execute macros in this workbooks from one place. (instead of
opening them individually and clicking the button)



"Dave Peterson" wrote:

What do you mean by this:

All sheets have macros.

Does this mean that you have events associated with various worksheets or that
all spreadsheets(=workbooks) have macros?

If you mean that each workbook has the same macros, you could remove all that
code and create an addin. Then give the user a way to run the common macro--via
options on the menubar or from a toolbar.

If you want to add an option to the worksheet menu bar, I really like the way
John Walkenbach does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

flow23 wrote:

I have various excel database with macros. All sheets have macros. Is it
possible to have a word file (a central place) where user can click a button
and run those macros?

--

Dave Peterson