Excel VBA - How to get rid of the Minimize/Restore/Close at the far right of a menubar and the Excel icon at the far left?

I don't think you can get rid of the control box for the Excel Application. Only for user forms.

If its in a custom menu, then just remove those icons from it? I don't see what icons on any default menus except under File.

You could override the Private Sub Workbook_BeforeClose(Cancel As Boolean) by setting cancel to true within that procedure.

oh ya, if you set cancel = true, you need to put some kind of conditional there or you cannot close the workbook at all.

Heh, gives me an idea for a good prank.

The icons aren't under any menu, they're to the far right of the menu bar, to the right of the "Type a question for help" in the default Worksheet Menu Bar.

Try this: http://support.microsoft.com/kb/814562
Regards,
Rory
PS Note the comment about the availability of Application.hWnd in Excel 2002 and up.

Rory,

This was a great link.  However, it got rid of the control menu and the minimize/restore/close functionality above the toolbar, at the top left of the window bar and the top right of the window bar.

There is still a control menu and minimize/restore/close functionality right below that on the Worksheet Menu Bar.  I am attaching an image file that highglights this.

Possibly what you pointed me to could be used to get rid of these as well but I couldn't figure out how to get the hWnd of the window internal to Excel.
excel-control-menu-and-close-fun.gif

Can I ask why you're wanting to get rid of those buttons? How do you intend to close the workbook then?

There's a custom Exit button on the toolbar.  Any changed data gets written to a special file, not saved in the spreadsheet.  I do not want users to do anything other than allowed by the custom toolbar.

After futilely trying to figure out what the hWnd of an internal Excel window is, I've decided to take both your advice and just let the user do whatever he wants and just handle the exit behavior.