I added a few worksheets to my workbook, now all the macros in that
workbook run atleast 20 times slower. I have my older version saved and
it works fine, so I made another copy and tried moving this one sheet in
and slow macros again. This sheet in question consists of about 6
columns completely filled with formulas containing the indirect
function. It's serves the purpose of displaying the status of my
current jobs as well as a button for the user to list them
alphabetically. Maybe I went about the creation of that sheet wrong. I
don't understand why it would slow each and every macro down on all the
other pages. Is it possible the sheet could be calculating these
indirect references during every macro, I don't understand why it would
do that, but it's the only logical thing. There must be some kind of
code to put in the sheet module to disable the sheet from calculating
until I select the sheet. Or do I need to make a macro that enters
these indirect references into the cells when the sheet is selected,
then clears them upon exit of the sheet? Beats the you know what outa
me.


--
famdamly
------------------------------------------------------------------------
famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=521643