Thread: Menu Items and Disable/Enable in Excel 2003
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ken Macksey Ken Macksey is offline
external usenet poster
  
Posts: 77
Default Menu Items and Disable/Enable in Excel 2003
Hi

This worked for me in excel 2002.

Application.CommandBars("Worksheet Menu
Bar").Controls("&Tools").Controls("&Customize...") .Enabled = False

HTH

KenM


Reply With QuoteReply With Quote