Disable Minimize/Maximize button in Worksheet Menu 1

[Bitaoo]

Hi,

I found out that if I run the following code:

Application.Commandbars("Worksheet Menu Bar").Enabled = False

All the menu bar will diapears and also Minimize/Maximize buttons at the right top of winodw goes away. But I need to have the menu bar, I just need to disable Minimize/Maximize buttons. Please help, how can I do that?

Thanks,
--Bita

 

[GlennUK]

The buttons on the Worksheet menu depend on whether the Workbook is protected ( Windows ) or not. Do
ActiveWorkbook.Protect Structure:=True, Windows:=True
and see if it does what you want.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Bitaoo]

Thanks a lot, it solved my problem.
--Bita