Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    543
    Thanks
    56
    Thanked 0 Times in 0 Posts

    Copying toolbars (OXP)

    I have created a toolbar, attached to a document, that uses macros to carry out specific functions. I wish to copy this toolbar to other documents.
    Can anyone help with this as the task needs to be replicated about 30 times, a lot of tedious work.
    cheers

    Phil Carter

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying toolbars (OXP)

    Hi Phil:
    One of the VBA experts may have a better solution, but if you really want these macros & toolbar available to so many documents, wouldn't it be easier to save it as a template & then load it as an add-in (or even as a global template)? Then it would be available whenever you needed it. Another solution would be to save it as a template & use it as the attached template for that type of document.

  3. #3
    4 Star Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    543
    Thanks
    56
    Thanked 0 Times in 0 Posts

    Re: Copying toolbars (OXP)

    Sorry Phil

    I didn't explain very well. The documents are already saved as templates with the tool bar attached.

    I have made an addition to the toolbar which I now want to copy to all the documents.
    cheers

    Phil Carter

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Los Angeles Area, California, USA
    Posts
    7,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying toolbars (OXP)

    Hi Phil:
    Still, instead of having so many templates with the same toolbar, couldn't you have one template that you load as an add-in or put in the startup folder? Then you only have to change the toolbar in one location, unless I'm missing something (wouldn't be the first time). <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •