LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Excel, Fullscreen, Taskbar

I'm new with Forums and Newsgroups

I've already posted this question in MSDN Forums » Microsoft ISV Community
Center Forums » Visual Basic for Applications (VBA). But I found this morning
that Newsgroups should be a better place for my subject.

So I'm sorry if you have read my question before

I use Windows 2000 Pro and Office XP

When I open Excel, all the elements of the application appear above the
Windows task bar. (I see the sheet tabs, status bar and task bar)

When I select fullscreen (with Application.DisplayFullScreen = True), the
status bar and sheet tabs are hidden behind the task bar.

Hint: I've found that, when I put the task bar on the left side of the
screen and after put it on the bottom, the status bar and sheet tabs reappear
above the task bar, or if I set the task bar in AutoHide and set always on
top afetr. But these are not good options for my users, nor is hidding the
task bar.

First question: Is it possible to keep the status bar and sheet tabs
automatically above the task bar, when I select fullscreen option. (with a
setup or a macro)

When Excel is in fullscreen mode, and I minimise it (with
Application.WindowState = xlMinimized), and then restore it, Excel restore in
normal mode, instead of fullscreen.

Second question: Is it possible to restore Excel in fullscreen mode or write
a macro that will execute automatically to select fullscreen when Excel is
restored.

Note: Any solution that doesn't use fullscreen option will not fit.

Thanks


 
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
userform fullscreen Pierre via OfficeKB.com[_2_] Excel Programming 4 November 4th 05 10:14 AM
deactivate fullscreen MD Excel Programming 3 March 13th 05 08:52 PM
How do I reset default Excel window too view=fullscreen needyourhelp Setting up and Configuration of Excel 4 March 7th 05 10:37 PM
FullScreen Question MD Excel Programming 0 January 6th 05 02:10 PM
Fullscreen Michelle Excel Programming 1 August 13th 04 02:31 PM


All times are GMT +1. The time now is 11:57 AM.

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

About Us

"It's about Microsoft Excel"