disable window bar at top of screen in XL.

[randall78]

I have a XL 2010 spreadsheet that opens in full screen and a button to save and exit, and I have disabled the Esc Key and right mouse click. What I need to do how is remove the control bar at the top of the window (menu on the left side and Minimize/restore/close on the right) any ideas please. If there is some code for this I will also need to know where to put it. Thanks

[abousetta]

I believe this is the code:

Please Login or Register  to view this content.

[royUK]

I believe this is the code:

Please Login or Register  to view this content.

That hides the worksheet's headings, not the close, minmise buttons

[abousetta]

You are right Roy, then I guess they should use the FullScreen approach to hide the Minimize/restore/close options.

[JosephP]

full screen doesn't remove those-you need api calls

Please Login or Register  to view this content.

as an example

[abousetta]

Hi Joseph,

You are completely correct that the Windows API is required to remove it the options from the root. I tend to just keep the workbook at fullscreen, therefore hiding the options.

I wasn't able to make the example you provided work. Could you please upload it in an example workbook?

Thanks.

abousetta

[JosephP]

I reckon that's because we're talking about different things. full screen mode does not hide the minimize/maximize/close (title bar) of the application which is what the asker seems to want.

[abousetta]

Yes, you are correct. Not arguing with that. I just don't have a strong command of Windows API. Therefore I keep a loop in place to make sure that the workbook stays in fullscreen. If it is minimized or resized, it pops back into place. I agree that the Windows API approach is the correct way to go, I just can't seem to get it working from my end.

[JosephP]

here's an example. it removes the menus then goes full screen. press escape to exit full screen or just alt+f4 and restart excel to get it all back as normal.

[abousetta]

Thanks. I don't know why it didn't work for me this morning when I first tried it.

[randall78]

Thank you Josephp for the code it works a treat. had to tweak with some of mine to get it to work but cool been trying to do this for a wile.