View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default hiding Worksheet menu bar

Commandbars(1).Enabled = False

--
Regards,
Tom Ogilvy

"Yves Janssens" wrote in message
.be...
Hi,


Is it possible to hide the Worksheet menu bar?

What I'm trying is the following:
CommandBars(1).Visible = False

This gives me an error:
Error -2147467259(80004005) during execution:
Method Visible of CommandBas has failed


Many thanks in advance,

Yves