Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Unhide part of Full Screen button

When I use the Full Screen button in Excel 2002 it hides the menu row that
contains the cell reference and the fx box which shows the data selected or
being entered. Is there any way to keep this row showing when I am in Full
Screen?

Any help would be greatfully appreciated.

Roger
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 923
Default Unhide part of Full Screen button

Try this, the formula bar is hidden by DisplayFullScreen, but after you run
this the bar will always show.

Application.DisplayFormulaBar = True

Cheers
Nigel

"Roger Bedford" wrote in message
...
When I use the Full Screen button in Excel 2002 it hides the menu row that
contains the cell reference and the fx box which shows the data selected

or
being entered. Is there any way to keep this row showing when I am in

Full
Screen?

Any help would be greatfully appreciated.

Roger



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Unhide part of Full Screen button


Thanks, your macro was exactly what I needed!

Roger


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Unhide part of Full Screen button





*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Reply
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
full screen Tree*Rat New Users to Excel 1 October 20th 08 09:26 AM
Opening in Full Screen. skrol New Users to Excel 4 September 22nd 05 09:37 AM
i can not get full screen to remain off BabyBlueAXiD Excel Discussion (Misc queries) 1 August 26th 05 03:19 PM
Full Screen Button Kaval[_2_] Excel Programming 2 May 10th 04 06:34 AM
Resetting Screen to Full Ron de Bruin Excel Programming 1 November 5th 03 07:24 PM


All times are GMT +1. The time now is 03:23 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"