Grey bar at top during full screen

[maclav]

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?

 

[WalkerEvans]

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.





----------------------------------------------------------------------------------
[small]How did the newspaper describe the swindler who fell off the prison roof during an escape attempt?[/small]
They used a condescending remark.

 

[maclav]

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.

 

[SkipVought]

Please post your relevant code.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[maclav]

Not sure it is going to be much use but here it is. Have changed the names of the sheets.

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

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

End Sub

 

[SkipVought]

Could not duplicate the issue.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]

 

[maclav]

Meh dont worry about it. I am only in this job 4 more days.

 

[WalkerEvans]

maclav,

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

Sorry.



----------------------------------------------------------------------------------
[small]How did the newspaper describe the swindler who fell off the prison roof during an escape attempt?[/small]
They used a condescending remark.

 

[maclav]

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.

 

[AnotherHiggins]

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.