Programmatically Disable Taskbar
 

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...b;en-us;290150

Programmatically Disable Taskbar
 

There's a much simpler way to avoid the problem

Tools, Options, View
Uncheck "Windows in Taskbar"

I really don't know why it's enabled by default

In code
Application.ShowWindowsInTaskbar = False

If you are doing that for other users store the setting first and reapply
when done.

It's n/a in xl97, if necessary cater appropriately to avoid error

Regards,
Peter T

"Stephen Lloyd" wrote in message
...
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...b;en-us;290150

Programmatically Disable Taskbar
 

Thank you very much! Even though it smarts, I love when things are simpler
than I tend to make them.

I'll try it out.

"Peter T" wrote:

There's a much simpler way to avoid the problem

Tools, Options, View
Uncheck "Windows in Taskbar"

I really don't know why it's enabled by default

In code
Application.ShowWindowsInTaskbar = False

If you are doing that for other users store the setting first and reapply
when done.

It's n/a in xl97, if necessary cater appropriately to avoid error

Regards,
Peter T

"Stephen Lloyd" wrote in message
...
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...b;en-us;290150