I have the new 2007 version and many macros written over the years that I had
in older versions of excel as toolbars. Some I use at home some are used in
other businesses for access control and document management. Now I can Add
the toolbars in to the new version, but I can't see a way to edit the buttons
to point at the macros themselves which are in another workbook, which has
also moved location since the install. I could do this programmatically, but
right now I'm hoping that I'm missing something obvious and simple in the
other menus. Does anyone know where this is.
In older versions you could edit the toolbar whilst the customise option was
open.

I'm so irritated that I might even un-install this expensive new version for
an old '95 I have on the shelf.

On Jun 25, 2:14*pm, Ian <I...@discussions.microsoft.com> wrote:
> I have the new 2007 version and many macros written over the years that Ihad
> in older versions of excel as toolbars. Some I use at home some are used in
> other businesses for access control and document management. Now I can Add
> the toolbars in to the new version, but I can't see a way to edit the buttons
> to point at the macros themselves which are in another workbook, which has
> also moved location since the install. I could do this programmatically, but
> right now I'm hoping that I'm missing something obvious and simple in the
> other menus. Does anyone know where this is.
> In older versions you could edit the toolbar whilst the customise option was
> open.
>
> I'm so irritated that I might even un-install this expensive new version for
> an old '95 I have on the shelf.

I read somehwere fairly recently that in Excel 2007 Microsoft disable
the users from having a Macro toolbar.

Just my two cents worth.

Steve

Hi Ian

Check out this page
http://www.rondebruin.nl/qat.htm

See also the other pages in my 2007 section


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ian" <(E-Mail Removed)> wrote in message news:4B85C38E-CA15-4CDC-B7AE-(E-Mail Removed)...
>I have the new 2007 version and many macros written over the years that I had
> in older versions of excel as toolbars. Some I use at home some are used in
> other businesses for access control and document management. Now I can Add
> the toolbars in to the new version, but I can't see a way to edit the buttons
> to point at the macros themselves which are in another workbook, which has
> also moved location since the install. I could do this programmatically, but
> right now I'm hoping that I'm missing something obvious and simple in the
> other menus. Does anyone know where this is.
> In older versions you could edit the toolbar whilst the customise option was
> open.
>
> I'm so irritated that I might even un-install this expensive new version for
> an old '95 I have on the shelf.
>