+ Reply to Thread
Results 1 to 1 of 1

HTML not calling VBA function?

  1. #1
    Forum Contributor
    Join Date
    03-07-2013
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    274

    HTML not calling VBA function?

    Hello,

    I have to plead ignorance.... I really need some help with this.

    Please skim over the following HTML/VBA code within my Excel project:


    Please Login or Register  to view this content.
    Above, customButton9 is a button on the ribbon. When I click on this button, I successfully run the DisplayDevTools() residing in the RibbonX VBA module.

    First I am a little confused as to what Rib.Invalidate really does?


    After the Rib.Invalidate statement, the HTML code should get to this line:

    <tab idMso="TabDevelopper" getVisible="RibbonX.GetVisible" />

    which should fetch the GetVisible() function ... but it never does???


    From what I could understand from Rob the bruin's examples, is that the Rib.Invalidate statement should refresh the ribbon and in turn should call the GetVisible()... and its not happening???

    Why is it that in his examples shown here:

    http://www.excelforum.com/excel-gene...e-explain.html

    which show this principle and it works?? What am I doing wrong in my example above??


    Other references I have posted this same question is:
    http://www.excelforum.com/excel-prog...-function.html



    Sincere thanks in advance to all !
    RN
    Last edited by RustyNail; 05-26-2015 at 10:13 AM.

+ 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. Replies: 5
    Last Post: 09-15-2014, 12:41 AM
  2. [SOLVED] Calling a function
    By grkchakri in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-04-2013, 10:57 AM
  3. Macro exits prematurely from function after calling other function
    By LouisPhilippe in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-22-2013, 03:22 AM
  4. [SOLVED] help with calling a function (B) and return control of program flow to the calling functio
    By john/nyc in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-26-2012, 11:06 AM
  5. How to get TOC shown in HTML Help when calling from VBA?
    By myunker in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-08-2006, 11:50 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