Results 1 to 13 of 13

Thread: Questions from a customUI newbie

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #9
    VBAX Contributor
    Joined
    May 2008
    Posts
    198
    Location
    Quote Originally Posted by Aflatoon View Post
    It is possible to access the ribbon through VBA using the accessibility objects interface but it's pretty convoluted and if VBA is disabled anyway, that's not really going to help you.
    Thanks, I'll look into that. It may do what I need (assUming I can access a specific ribbon element directly through a VBA macro), the issue is that I want to display a label when the macros are disabled. I cannot use the getVisible callbacks (since the value will be false when the macros are disabled, I could only set the visiblity true when they are enabled). If I could either make them invisible, or set their label to an empty string, through a macro, this may do what I need.

    Quote Originally Posted by Aflatoon View Post
    If you're using Excel there's an article in the KB here about prompting users to enable macros, but I don't know how you enforce it in other applications.
    I'll check around to see if there's any other discussion of enforcing macros for Word.

    Thanks again for all of your help.


    Edit: 'convoluted' was a pretty accurate description. I found a demo which will select a specific element on the ribbon, and run it's action, but I'm having a hard time determining if it's possible to change their visibility or text, and if so, how to do it.
    Last edited by Cosmo; 10-08-2013 at 06:22 AM.

Posting Permissions

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