Vba to hide close button on excel application

[Sintek]

Hi All

I found this workbook on line which contains code to hide the close button. It works great, but am not able to see the code that actually does the trick. I want to be able to hide the button on workbook open event. Can anyone perhaps have a look and see how i can adapt to suite my needs.

[:) Sixthsense :)]

But it is not working for me as you described.

Tested it on Windows-XP (xl 2010 version)

[Sintek]

Hey there Sixthsense

I'm using Windows-7 Excel 2007

[xlnitwit]

It works great, but am not able to see the code that actually does the trick.

The code is in module 2 and the ShowCaption routine is called by the code in Sheet1.

[Sintek]

Hi xlnitwit

Thanks for reply... What part of the code runs when I press [False]. The part actually hides the x.
How can i get the code to hide the x when the workbook opens.

[xlnitwit]

Look at the code in Sheet1- there is one routine for each button. They both call the same routine but one passes True as the argument, the other False.

[Sintek]

I'm a dumb dumb...Now I get it.

Thanks xlnitwit for clearing that up for me.