ExcelBanter - hiding Worksheet menu bar

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - hiding Worksheet menu bar (https://www.excelbanter.com/excel-programming/277269-re-hiding-worksheet-menu-bar.html)

Bob Phillips[_5_]

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

All times are GMT +1. The time now is 07:16 AM.