View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DENISE DENISE is offline
external usenet poster
 
Posts: 12
Default 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