Yes, I understand that. However, the program flashes before it even calls
the other subroutine. The code goes:

wksTemp.Activate
call OtherSub

As soon as I try to activate the other worksheet, the view flashes. The
same thing happens after CodeCleaning, restart, or closing the VBE.

I don't know what's going on here. I must have done this 50 times before,
and I've never had this issue.

matthew pfluger

"Jim Thomlinson" wrote:

Not sure if you caught my drift (I could still just be missing something). If
eithier of your procedures that you call toggle the screen update settings
then you are going to get flashing..

so if your sub looks like this then you have an issue
public sub SheetFormatting
application.screenupdating = false
'do stuff
application.screenupdating = true 'Problem here...
end sub

In any case you can just remove your application.screenupdating = true code
lines as this is a setting that automatically resets whenthe procedure is
done... As a matter of good housekeeping I always reset it but it is not
necessary.

--
HTH...

Jim Thomlinson


"Matthew Pfluger" wrote:

No, the ScreenUpdating is still on before the other procedures are called.
Also, that subroutine is designed to be run with ScreenUpdating off.

"Jim Thomlinson" wrote:

I notice that you have calls to other procedures. If those procedures tun the
screen updating on then there is your issue...

Call GetListOfYearTaskSheets(colTasksSheets) 'here possibly???
--
HTH...

Jim Thomlinson