+ Reply to Thread
Results 1 to 4 of 4

Macros and Custom UI editor

  1. #1
    Registered User
    Join Date
    01-08-2015
    Location
    Egypt
    MS-Off Ver
    2007
    Posts
    13

    Wink Macros and Custom UI editor

    Hello
    i have this custom UI
    Please Login or Register  to view this content.
    is there a way to create user form with a password txtbox to disable and enable this customUI .
    Thanks

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

    Re: Macros and Custom UI editor

    No. The startfromscratch will already have occurred as the file opens and there is no related callback to pass the True/False value as an argument.

    Closest you could get is to use the getVisible callback on all builtin tabs. Any custom add-in tabs would remain
    Cheers
    Andy
    www.andypope.info

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

    Re: Macros and Custom UI editor

    Actually if you go the other way you can get it to work.

    Startfromscratch = true. and then getvisible of the built-in tabs.

    This example will show the first 4 tabs if you enter Fred.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    01-08-2015
    Location
    Egypt
    MS-Off Ver
    2007
    Posts
    13

    Re: Macros and Custom UI editor

    well , that's great thanks :D ,,one more thing how do i disable start from scratch after opening ? can i do that with a command button , i just started using customUI so i don't know anything about it :/
    Thanks

+ 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. Assistance with Custom Tab and Groups on Excel Office Ribbon using Custom UI Editor.
    By sdavison in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2015, 06:13 AM
  2. [SOLVED] Custom UI Editor---->ComboBox Question
    By HerryMarkowitz in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 08-23-2014, 07:20 AM
  3. [SOLVED] Custom UI Editor
    By britinva in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-04-2014, 09:10 AM
  4. How to create custom tabs using CUSTOM UI EDITOR in excel 2007
    By narendrabr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2014, 12:38 PM
  5. Problem using the new version of custom UI Editor
    By mridzuani in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-21-2011, 05:03 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