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/277268-re-hiding-worksheet-menu-bar.html)

Tom Ogilvy

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

All times are GMT +1. The time now is 05:31 AM.