Commandbar Position

Tech-Archive recommends: Fix windows errors by optimizing your registry

I asked this question earlier but got no reply. I want my commandbar
(a toolbar attached to a workbook) to always appear as the bottom-most
commandbar at the top of the screen, centered horizontally, when the
workbook opens. Seems like this shouldn't be all that difficult, but
apparently it is a problem in Excel (2002). Thanks! James

.

Relevant Pages

  • Re: icon disapears from tool bar
    ... Your toolbars are not saved with the workbook, they are saved in a separate ... Create a whole separate toolbar and either attach it to ... macro from the WindowActivate event, rather than the Open event because I ... may have two workbooks open that use the same commandbar. ...
    (microsoft.public.excel.programming)
  • Re: How to deploy custome toolbar/Menu commands in Excel?
    ... ' Sample Code for CommandBar Creation ... Sub CreateCommandbarSample() ... The OnAction property must be the name of a procedure in the workbook. ... > i added one custome toolbar now problem comes when i want that file to ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Filename leads MacroName
    ... The best option is to create the commandbar on the fly, when the workbook is ... Private Sub Workbook_BeforeClose ... I put drawing objects and .jpg's in some of my workbooks and assign macros ...
    (microsoft.public.excel.programming)
  • Re: Hiding a toolbar
    ... You can test for the existence of the commandbar but I'd go with your easier ... > workbook_close event to kill the toolbar. ... I tried to have simply "On error exit sub" but VBA didn't like ... >>> I have a floating toolbar in a workbook. ...
    (microsoft.public.excel.programming)
  • Re: Travelling Toolbars and hidden macro sheets
    ... You could open another file using the workbook open event, and run macros ... The best option is to create the commandbar on the fly, ... Private Sub Workbook_BeforeClose ...
    (microsoft.public.excel.worksheet.functions)