I have a workbook which has a workbook open event and asks the year to
run a report. Everything is great when opened individually. the
problem is the workbooks also get opened from a summary workbook that
opens 50 workbooks in the same folder. the question asking the year
keeps on coming up 50 times (once for each workbook)

I don't remember if it is possible to disable the workbook open macro.
It seem lie my only solution is to disable the workbook open and have
the users run the report manually. To have the report run automatically
when another workbook opens the macro would require adding a short macro
to the workbook excepting the year as a parameter and then calling the
report macro.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=175816

Microsoft Office Help