+ Reply to Thread
Results 1 to 3 of 3

Excel 2002 Toolbar Hide Custom Button Macro

  1. #1
    Registered User
    Join Date
    09-14-2018
    Location
    Christchurch, New Zealand
    MS-Off Ver
    2002
    Posts
    2

    Question Excel 2002 Toolbar Hide Custom Button Macro

    I have been creating custom buttons for VBA / Macros for Excel 2002 (sorry, don't like or need the ribbon) for quite a while now but I was wondering if there is a way to make a custom button that only shows in specific workbooks instead of every workbook?
    I see how you can restrict the macro to just selected workbooks but not the custom button you assign to the macro ~ thanks.
    (apologies if this has already been answered somewhere else as I have had no luck with Google so far)

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,014

    Re: Excel 2002 Toolbar Hide Custom Button Macro

    .
    This works with Excel 2007 :

    Please Login or Register  to view this content.
    Don't forget to UNHIDE the menu bar when you close the workbook or all of your subsequent workbooks will display without the menu bar.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-14-2018
    Location
    Christchurch, New Zealand
    MS-Off Ver
    2002
    Posts
    2

    Re: Excel 2002 Toolbar Hide Custom Button Macro

    Thanks Logit but none of your code is relevant to my issue except that I now see that I could use separate macros to hide the whole custom toolbar instead of just the custom button in each workbook as a Mickey Mouse workaround.
    I didn’t think it would be this difficult to do and to be honest, I didn’t think I would have to resort to different macros for each workbook to do it but maybe that’s’ the price I have to pay for sticking with the old Excel 2002.
    Thanks for being the only expert to reply so far.

+ 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. Macro's assigned to a custom toolbar button don't run after renaming the worksheet
    By marcelw in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-24-2007, 02:56 AM
  2. Custom Toolbar and button with macro
    By matpj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2006, 10:09 PM
  3. Replies: 2
    Last Post: 08-22-2006, 12:55 PM
  4. Custom Toolbar Button No Longer Runs Assigned Macro
    By Bryan in forum Excel General
    Replies: 1
    Last Post: 04-10-2006, 01:10 PM
  5. [SOLVED] to remove a custom Toolbar Button & macro
    By luminore in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2006, 04:25 PM
  6. Removing a custom Toolbar Button & macro
    By luminore in forum Excel General
    Replies: 1
    Last Post: 02-08-2006, 03:45 PM
  7. Removing a custom Toolbar Button & macro
    By luminore in forum Excel General
    Replies: 0
    Last Post: 02-08-2006, 03:05 PM
  8. [SOLVED] Add standard excel button to custom toolbar menu
    By Gixxer_J_97 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-21-2005, 03:20 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