Hide the blue bar and/or Excel Close (Red cross) button

[StuLux]

Is it possible to hide the Excel application bar (normally blue bar including the maximise, minimise and close buttons). If the bar itself cannot be hidden is it possible to remove (or disable) the buttons.

I have created an application that has user buttons for all the necessary functions to navigate, save and close the workbook and I don't want users to be able to close the workbook in any other way.

 

[Russ At Index]

Hi StuLux,

Check out John Walkenbach's page link below..

http://j-walk.com/ss/excel/tips/tip80.htm

Or

Search for "Captionless Userform" on this forum

HTH

Russ

 

[StuLux]

Thanks for the pointer but this talks about the close button in a user form (not sure exactly what that means) it is the clsoe button of the Excel application I want to disable. Looks like this may not be possible?

 

[Russ At Index]

Hi StuLux,

Give this a whirl .... er.. forum search i mean !!!!!

"Eliminate min max and close"

HTH

Russ