+ Reply to Thread
Results 1 to 4 of 4

Creating document level Excel AddIn

  1. #1
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Creating document level Excel AddIn

    Hi,

    How can I make my custom xlam addin to load in Workbooks that have specific name, means it should not load in every instance of Excel but if a pre-saved book with name like "MyBook*.xlsm" open then it should work with those books only and after closing one book the addin should also be uninstalled from that workbook only and not those of the criterion other workbooks that are currentluy opened.

    How to make this happen?


    Help would be greatly appreciated

    Best Regards
    Imran Bhatti
    Teach me Excel VBA

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Creating document level Excel AddIn

    You would need to add callbacks to the ribbon to to toggle the visible property of the Tab.

    example zip attached contains addin file. The firewall would not allow me to post the code for some reason.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Creating document level Excel AddIn

    Thank you sir Andy. Currently a batch process is running on my PC. Will let you know after testing.

  4. #4
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,784

    Re: Creating document level Excel AddIn

    Thanks
    Just had to add a reason just like "Range("XFD1").value= "X"

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Invalid at the top level of the document XML parse in VBA
    By jaryszek in forum Excel General
    Replies: 1
    Last Post: 11-15-2017, 03:41 AM
  2. [SOLVED] Creating a button to call an Excel Addin
    By Tonan230 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2016, 12:02 PM
  3. [SOLVED] Creating a MS Word Document from Excel
    By jason_lee_91 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-26-2012, 02:09 PM
  4. creating pfd document(s) from excel
    By SystemsAccountant in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-06-2009, 12:55 PM
  5. Creating Hyperlink in Excel to PDF document???
    By Alastair Hogben in forum Excel General
    Replies: 0
    Last Post: 11-10-2005, 08:00 AM
  6. Creating Excel Addin
    By salooha in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-28-2005, 11:44 AM
  7. creating a document from an Excel row
    By Phil in forum Excel General
    Replies: 0
    Last Post: 02-27-2005, 10:06 AM

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