View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_5_] Bob Phillips[_5_] is offline
external usenet poster
 
Posts: 620
Default hiding Worksheet menu bar

Yves,

Use

CommandBars(1).Enabled = False


Don't forget to reset!

--

HTH

Bob Phillips

"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