comandbars/toolbars
Hello
I've been experimenting with
Application.commandbars(1).enabled = false
to disable toolbars
Question 1)
How many commandbars/toolbars are there (or how can I find
out) and how can you tell what number they are eg
Commandbar(1) is the menubar
Question 2)
Is there anyway of remembering which commandbars a user
has enabled, disable them when your workbook is opened and
enable them again when your workbook is closed.
Many thanks in advance
|