+ Reply to Thread
Results 1 to 2 of 2

Sharing Custom Menus

Hybrid View

  1. #1
    Registered User
    Join Date
    10-25-2005
    Posts
    1

    Sharing Custom Menus

    I have a series of macros that I would like to share with others at my office. I'm comfortable with sending them the .xls file from the xlStart folder that has the macros. However, I would also like to share my customized menu that runs many of the macros. Can anyone explain how I can share the custom menus with others?

    Thanks in advance!

  2. #2
    tra
    Guest

    Re: Sharing Custom Menus

    It is possible to write a macro to do this, but a simpler solution is
    to open the spreadsheet you will be sending them then go to
    Tools|Customize... and on the Toolbars tab click New...
    This will make a custom toolbar. Drag your custom menu on to this
    toolbar. Then, click on Attatch... and select the custom toolbar you
    just made. Then click on Copy >> then OK then Close.
    Your custom toolbar is now stored in the spreadsheet. When the person
    you're sending it to opens it, they will have your custom toolbar, with
    the menu on it.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1