Mac Forum / Applications / Excel / January 2006

> Francis Hookham a écrit :
>
>> On opening only Standard toolbar is in view ­ I have not found how to
>> default to all toolbars on view
>>
>> Better still, how about a custom toolbar with only the buttons I normally
>> need, as in XL 2000 - or didn¹t Bill think Mac users needed it as much as PC
>> users?
>
> There is a workaround, borrowed from JE McGimpsey that does fit the bars
> where I like to have them. You can copy the following lines in a macro
> module of your "Personal Macros Workbook"
>
> ----------------------------------------------------
> Public Sub SetUpVBEToolbars()
>         Const LEFTPOS = 752   ' these are my settings
>         Const TOPPOS = 21     ' adapt them to your needs
>         Const ROWNDX = 2
>        
>        With Application.VBE
>             'With .CommandBars("Edit") ' Edition
>             '     .Visible = True
>             'End With
>             With .CommandBars("Debug") ' Débogage
>                 .Position = msoBarTop
>                 .RowIndex = ROWNDX
>                 .Left = LEFTPOS
>                 .Top = TOPPOS
>                 .Visible = True
>                 .Protection = msoBarNoMove
>             End With
>             .Windows("Properties").Visible = True
>         End With
> End Sub
> ----------------------------------------------------
>
> In order to have it automatically launched on statup, put these lines in the
> ThisWorkbook code sheet of the "Personal Macros Workbook":
>
> ----------------------------------------------------
> Private Sub Workbook_Open()
>     SetUpVBEToolbars
> End Sub
> ----------------------------------------------------
>
> That way, when your personal macros Workbook is automatically opened on
> Excel startup, the bars will be placed where you'd like to have them.
> Unfortunaltely, there's no way (that I know) to customize these bars.
>
> The Mac VB Editor is certainly much "simpler" than its Windows equivalent...
> The Mac User is usually supposed not to use VBA that much and/or to be a
> rather good AppleScripter if he wants to automate things :-/
>
> ---------------------------------------------------------
> Please reply to the newsgroup, and within the same thread.
> Merci de répondre au groupe, et dans l'enfilade.