Flow,

I've done the following as an example:

I created Book2.xls Book2 has the following macro in it:
Sub temp_book2()
ThisWorkbook.Sheets(1).Cells(3, 3) = "abc"
End Sub

I next created Book3.xls. In sheet1 I put a rectangle and added text to it
-- just the word "run", it could of course be anything. Then, right
clicking, under "assign macro", I put: Book2!temp_book2

Now, clicking on that rectangle causes the macro in Book2 to run.

Art




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