I'm sure I saw a post here once about doing this but can't find it now.
I have a CommandBar.add macro on startup that loads a bunch of buttons and
associated functions. i.e. a series of

Set Button1 = mybar.Controls.Add(Type:=msoControlButton)
With Button1
.Style = msoButtonIcon
.Picture = LoadPicture(ThisWorkbook.Path & "\FirstPicture.bmp")
.TooltipText = "run the first macro"
.OnAction = "FirstMacro"
End With
Set Button2 = mybar.Controls.Add(Type:=msoControlButton)
........ etc etc etc

All running OK but as different people request functions that are only
needed by 1 or 2 colleagues, the toolbar is getting wider and wider.
I want to give the users some configuration options, such as individually
setting the files in a "frequently used files" menu or deciding which
functions/buttons will be displayed and which not.
What would be the best way to approach this ?

The only way I can think of (with my limited abilities) is through a "setup"
form with check boxes linked to cells in the xlt, but how can I get those
TRUE or FALSE values to determine what parts of the CommandBar creation macro
get used ?
Do I need to create a settings file (txt ?) somewhere and have a macro read
it on startup (and how would I do that) ?


--
WinXP - Office2003 (Italian)