LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 48
Default 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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Disable a taskbar steve Excel Discussion (Misc queries) 2 June 9th 05 06:24 PM
Disable Macros in workbook programmatically quartz[_2_] Excel Programming 2 April 2nd 05 03:31 AM
Programmatically disable new smart options Mike Mullane Excel Programming 0 February 16th 05 08:11 PM
How to disable autoopen() programmatically Karl Steinam Excel Programming 2 September 30th 04 06:35 PM
Does anyone know how to programmatically disable Application.xlcut Fonda Excel Programming 1 June 30th 04 01:58 AM


All times are GMT +1. The time now is 10:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"