Excel 2002 - Commandbar.protection = msoBarNoCustomize
 

I have a similar issue I hope someone can help with - I would like to
disable the "Add or Remove Buttons" drop down (only) as part of the
Workbook_Open procedure in an xla that deploys a set of custom
toolbars. I have tried experimenting with Jim's code above but nothing
happens if I just use the following statement (in Excel 2003):

Application.CommandBars.DisableAskAQuestionDropdow n = True

which I would have thought was correct. However, if I change the
property to "False", nothing happens either (i.e., the drop downs still
show).

Can someone suggest what I am doing wrong?

Thanks,

Jeff

Excel 2002 - Commandbar.protection = msoBarNoCustomize
 

Maybe:

Application.CommandBars.DisableCustomize = True

would work.

I think that this was added in xl2002. Are you going to run this in earlier
versions?



Jeff wrote:

I have a similar issue I hope someone can help with - I would like to
disable the "Add or Remove Buttons" drop down (only) as part of the
Workbook_Open procedure in an xla that deploys a set of custom
toolbars. I have tried experimenting with Jim's code above but nothing
happens if I just use the following statement (in Excel 2003):

Application.CommandBars.DisableAskAQuestionDropdow n = True

which I would have thought was correct. However, if I change the
property to "False", nothing happens either (i.e., the drop downs still
show).

Can someone suggest what I am doing wrong?

Thanks,

Jeff

--

Dave Peterson

Excel 2002 - Commandbar.protection = msoBarNoCustomize
 

Hi Dave,

Thanks for the suggestion. However, I don't want to disable the ability
to customize the toolbars so much as get back the space taken up by the
drop down arrow introduced in XP & 2003. And yes, I will be running
this across PC versions from Excel 97 through Excel 2003.

From my research thus far, it is beginning to sound like this can't be
done ...

Jeff

Excel 2002 - Commandbar.protection = msoBarNoCustomize
 

I don't know a way to hide that.

Jeff wrote:

Hi Dave,

Thanks for the suggestion. However, I don't want to disable the ability
to customize the toolbars so much as get back the space taken up by the
drop down arrow introduced in XP & 2003. And yes, I will be running
this across PC versions from Excel 97 through Excel 2003.

From my research thus far, it is beginning to sound like this can't be
done ...

Jeff

--

Dave Peterson