Suddenly slower running code...

Quick question... the code below was running fine in that it took about 2 seconds to do its job. Suddenly it now takes about 30 and I didn't change any of the code you see... From the VBA editor if I hit F8 and step through each line it seems to run fine with out hanging. It only runs poorly when started from the command button within the project.

Another clue... If I run it from the command button, wait about 10 seconds and hit the "Esc" key.. the process stops and I get my copied page just fine. I also tried commenting out various lines but cant seem to find the issue...

What other trouble shooting steps can I take to try and track this down???

Please Login or Register  to view this content.

Intresting you mention the event procedures, I did have one for another sheet that I ended up not using and to be safe, just commented it out... but nothing on the Tech Detail sheet I am copying. This sheet is dashboard style report that prints to 8-1/2 X 11, so nothing to huge. I have earlier versions of this same project that run fine... Something I did along the line caused this to happen...

No error with out the colon! I added them but still have a macro that is hanging up... Crazy it runs fine from the editor.. Tried removing "Application.ScreenUpdating = False" and watch the process... no help..


Also Tried removing this section as well as the password lines... no help.

shname = Worksheets("Tech Detail").Range("i3")
For Each sh In Worksheets
If sh.Name Like shname Then flg = True: Exit For
Next
If flg = True Then
MsgBox "A report already exsisits for " & shname
ActiveSheet.Protect Password = "safe"
Exit Sub
Else

$A$1 $X$73 I made a copy and deleted every formula and chart off the tech Detail sheet and it still runs slow. There is one cell set up as a data validation to a list of techs you would choose from. Cant seem to delete that...

I have auto calculation disabled as it takes about 20 seconds for this workbook to calculate.. (lots of big sumproduct formulas) I just noticed it seems to recalculating while the macro is running... can that be surpressed while the code is running?

AlphaFrog, I have to apologize... I talked my way into the fix... somehow I had auto re calculation turned back on...

Thank you for taking the time to help me focus on finding what I did to cause this!