Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Jumping bar at bottom of screen
Excel XP & Win XP
The bar I am talking about is the bar at the bottom of the screen that displays the names of the files/programs that are open. Obviously I don't know the name of that bar. I have VBA code that loops through about 25 files. The code opens each file, copies something from it, closes the file, moves on to the next file This causes that bar to jump around. My question: Is there some code that will freeze/unfreeze that bar (ScreenUpdating doesn't do it)? Thanks for your time. Otto |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Jumping bar at bottom of screen
Otto,
What are refering is called the "Task Bar" and is part of Windows, not Excel. You can prevent Excel from displaying each workbook in the Task Bar with the following code: Application.ShowWindowsInTaskbar = False -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Otto Moehrbach" wrote in message ... Excel XP & Win XP The bar I am talking about is the bar at the bottom of the screen that displays the names of the files/programs that are open. Obviously I don't know the name of that bar. I have VBA code that loops through about 25 files. The code opens each file, copies something from it, closes the file, moves on to the next file This causes that bar to jump around. My question: Is there some code that will freeze/unfreeze that bar (ScreenUpdating doesn't do it)? Thanks for your time. Otto |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Jumping bar at bottom of screen
Chip, Tom
Thanks for your help. Otto "Otto Moehrbach" wrote in message ... Excel XP & Win XP The bar I am talking about is the bar at the bottom of the screen that displays the names of the files/programs that are open. Obviously I don't know the name of that bar. I have VBA code that loops through about 25 files. The code opens each file, copies something from it, closes the file, moves on to the next file This causes that bar to jump around. My question: Is there some code that will freeze/unfreeze that bar (ScreenUpdating doesn't do it)? Thanks for your time. Otto |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop the screen from jumping | Excel Discussion (Misc queries) | |||
Calculate at bottom of screen does not go away | Excel Discussion (Misc queries) | |||
Private sub causes too much screen jumping | Excel Discussion (Misc queries) | |||
Can I keep the screen from jumping when running a macro? | Excel Programming | |||
The bottom of my spreadsheet is off the screen | Excel Discussion (Misc queries) |