Hi all,

Ok, I have managed to everything I needed to do bar manage to hide the Title bar of Excel which shows the document name.

Basically, my entire sheet shows nothing but the data/buttons/drop downs etc. There are no column or row headers / formula bars etc.

I have created a "Click to Close" button which will allow users to close the file and the code will not save the file.

What I am trying to do is to remove the title bar (which has the red close button) as if users use this to close the file it will ask them if they would like to save it (I know I can eliminate this with VBA), however my aim is to get the sheet not actually looking like Excel (hence removing all the standard Excel features).

Please could someone explain how I can remove this Title Bar. I have been given a page full of code by another user, however I can’t seem to be able to implement it.

My actions so far are:

1. ALT F11
2. Double click "This Worksheet"
3. Paste the code I have been given
4. Save, Close and Re-open

It does not come up with an error, it’s just not working.

Please help.....

Many thanks,

Andy.