I created an unrelated worksheet while trying to edit a simple macro, and
somehow that worksheet now opens up every time I run any macro. I have tried
to delete the macros from that particular worksheet, but it seems to have
ruined my macros. Yet I cannot find anywhere in any macro where it says to
open that worksheet.

My macros still show up in the Personal Macros workbook listing, but they do
not function properly. Is there anything I can do to repair the damage?
--
Richard Champlin
Administrative Program Assistant II
Children''''''''s Hospital & Regional Medical Center, Seattle

I'm guessing that the way you call the macros opens that other workbook (not a
worksheet in an already open workbook).

And I'm betting that you run the macro by clicking on a button. I bet if you
try to reassign the button to the correct macro in the correct workbook, then
the problem will go away.

But I don't know what kind of buttons you used--was it a button from the Forms
toolbar that was placed on a worksheet? Or was it a button on a commandbar?

Richard Champlin wrote:

I created an unrelated worksheet while trying to edit a simple macro, and
somehow that worksheet now opens up every time I run any macro. I have tried
to delete the macros from that particular worksheet, but it seems to have
ruined my macros. Yet I cannot find anywhere in any macro where it says to
open that worksheet.

My macros still show up in the Personal Macros workbook listing, but they do
not function properly. Is there anything I can do to repair the damage?
--
Richard Champlin
Administrative Program Assistant II
Children''''''''s Hospital & Regional Medical Center, Seattle

--

Dave Peterson