Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Grey bar at top during full screen

Status
Not open for further replies.

maclav

Programmer
Oct 29, 2007
28
GB
Hi
I have a project where i am turning excel into an application. I have made buttons that lead to the other sheets from a front sheet. when i lock it down it is fine but as soon as i move to another sheet the blank grey bar appears at the top.
One one got any ideas why this appears?
 
maclav,

Are you referring to the Row & Column headers? If so, you simply need to go to Tools > Options > View on each sheet and de-select this Window option. Unfortunately, I know of no universal way to do this - it has to be done just one sheet at a time.

[glasses]



----------------------------------------------------------------------------------
[small]How did the newspaper describe the swindler who fell off the prison roof during an escape attempt?[/small]
[spineyes]They used a condescending remark.[bugeyed]
 
No I have got rid of the headers but now when i go to each sheet a completly blank grey bar appears on the top blocking some of the sheet information.
In one case chopping the top off a button so you cant see what it says.
 




Please post your relevant code.

Skip,
[sub]
[glasses] When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[tongue][/sub]
 
Not sure it is going to be much use but here it is. Have changed the names of the sheets.

Code:
Sheets("A").Select
ActiveWindow.DisplayHeadings = False
Sheets("B").Select
ActiveWindow.DisplayHeadings = False

Code:
Private Sub A_Click()
Sheets("A").Select

End Sub
 




Could not duplicate the issue.

Skip,
[sub]
[glasses] When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[tongue][/sub]
 
Meh dont worry about it. I am only in this job 4 more days.
 
maclav,

I dedicated as time as I could to this, and could not duplicate your problem. Maybe someone else has a clue.

Sorry.

[sadeyes]

----------------------------------------------------------------------------------
[small]How did the newspaper describe the swindler who fell off the prison roof during an escape attempt?[/small]
[spineyes]They used a condescending remark.[bugeyed]
 
Its no problem thank you for doing so.
As I said the person who takes over my project when i leave can worry about it.
 
Out of curiosity, could you post a picture of what you are seeing?

If you need online space to save a screen capture, there is a link to the right of Step 3 Attachment under the window where you post.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top