Results 1 to 1 of 1

Excel 2007 Persistent tab for Add-in or macros book

Threaded View

  1. #1
    Registered User
    Join Date
    08-16-2012
    Location
    Costa Rica
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    7

    Question Excel 2007 Persistent tab for Add-in or macros book

    Overview:
    I have a shared macros book that is stored in a file server (I am planning/willing to convert it to an add-in), users run all their macros from the same common drive, every time I make a change in the server side the book is updated on the users’ side.

    In Excel 2003 I had a persistent menu that user would refer to in order to use the common macros (use by everyone in the office) that feature was removed in Office 2007 (yep… we just migrated to that).
    I tested the same procedure in Office 2010 and 2013 and the menu goes to the add-ins tab… which that kind of works but is not as convenient as having the menu right up front.

    The challenge:
    What I am trying to achieve is to have a ribbon tab Called Common Macros (or whatever) and under that have buttons calling the different macros we all use; however, this tab must be persistent, meaning that every time I open Excel the tab is visible. Because of the way we are setup using the personal.xlsb is not an option. The ideal solution is having a persistent tab but if that is not possible, I can settle by using a persistent menu in the Quick Access Toolbar. How do I achieve that using VBA? The user should be able to either install the add-in and see the menu or see the ribbon tab or run an installation macro and see the tab or the menu. I must stress that it has to be a persistent tab or menu.



    I will be very grateful if anyone can help me on this.
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel 2007 : How to save just one sheet from an excel wok book
    By stojko89 in forum Excel General
    Replies: 2
    Last Post: 05-15-2013, 09:55 AM
  2. Gather individual excel files into one book on Excel 2007?
    By Courierman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-22-2011, 03:05 PM
  3. Need Help Posting Excel Work Book w/ Macros to Web Page
    By cfscheibler in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2010, 01:33 PM
  4. Replies: 8
    Last Post: 02-13-2010, 03:29 PM
  5. [SOLVED] Open book, check for macros, close book
    By CLR in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-31-2005, 02:06 PM

Tags for this Thread

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