Programmatically Disable Taskbar

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
 
P

Peter T

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
 
S

Stephen Lloyd

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top