ExcelBanter - Disabling Menu Item

Thanks again to everyone for their help. Works perfectly!

"Ron de Bruin" wrote:

More ID information you can find here

http://support.microsoft.com/default...66&Product=xlw
XL97: List of ID Numbers for Built-In Command Bar Controls

http://support.microsoft.com/default...14&Product=xlw
XL97: Sample Macros to Return ID for a CommandBar Control

http://support.microsoft.com/default...55&Product=xlw
XL97: WE1183: "Customizing Menu Bars, Menus, and Menu Items"

http://support.microsoft.com/default...19&Product=xlw
XL97: Sample Macros for Customizing Menus and Submenus

http://support.microsoft.com/default...78&Product=xlw
XL97: Sample Macros That Customize and Control Shortcut Menus

--
Regards Ron de Bruin
http://www.rondebruin.nl

"JE McGimpsey" wrote in message ...
In article ,
"Bill" wrote:

I've never used the ThisWorkbook code module - what is the purpose of
that?

http://www.mcgimpsey.com/excel/modules.html

Also, if my company is using Excel 97, is it safe to assume the other
users who will open this workbook will have the Unprotect Sheet... I
of 893 also?

In all current versions it is. I suppose that it's possible it will
change, but given that it would break existing code, it's unlikely.

You could check for

Commandbars(1).Controls("Tools").Controls( _
"Protect").Controls("Unprotect Sheet...").Id

but if the active sheet is not protected, it will fail (since the
caption is changed to "Protect Sheet..."). It will also fail if the user
has moved the control to another location.