S
Stephen Lloyd
I've created an Add-In application that loops through files and tests the
value in a range in each file. Then it sends an email if the number doesn't
balance. There could be up to 40-50 files with any number of files having an
error. I've naturally set .ScreenUpdation = False.
I'm wondering if there is a way to temporarily disable the taskbar to
prevent each workbook from being placed on the taskbar and then removed each
time the loop iterates.
I have found code at the link below to hide and unhide the taskbar using API
calls, however, I'm wondering if, 1) even though it is hidden, it is still
updating? and 2) would the property values for toggling the taskbar window
have changed from Windows 98 to Windows 2k3? (I highly doubt they would have
changed.)
http://support.microsoft.com/default.aspx?scid=kb;en-us;290150
value in a range in each file. Then it sends an email if the number doesn't
balance. There could be up to 40-50 files with any number of files having an
error. I've naturally set .ScreenUpdation = False.
I'm wondering if there is a way to temporarily disable the taskbar to
prevent each workbook from being placed on the taskbar and then removed each
time the loop iterates.
I have found code at the link below to hide and unhide the taskbar using API
calls, however, I'm wondering if, 1) even though it is hidden, it is still
updating? and 2) would the property values for toggling the taskbar window
have changed from Windows 98 to Windows 2k3? (I highly doubt they would have
changed.)
http://support.microsoft.com/default.aspx?scid=kb;en-us;290150