Results 1 to 10 of 10

Vba code to hide specific cells

Threaded View

  1. #1
    Registered User
    Join Date
    03-08-2024
    Location
    Mexico
    MS-Off Ver
    Office 365
    Posts
    8

    Vba code to hide specific cells

    Hi everyone

    I´m constructing the file attached in order to have my workshop processes simplified. I´ve applied VBA coding to the cells where Main Categories (deep blue) and Subcategories (light blue) are placed (I have inserted button and then applied macros to them) so that the desired result is that they hide the cells with the range specified.

    However I´m having trouble when clicking on Main Categories buttons (the four big-blue ones) because all cells of the category deploy, when in reality what shoud be is that only the Subcategories buttons are deployed (like in the attached image), so then its the user the one that decides which Sucategory to deploy.

    Is there a way to change the code I applied in order to get this desired effect?
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Hide/Unhide Scroll Bars Code for Specific Sheets
    By crazyforexcel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-21-2019, 09:28 AM
  2. Help with ToggleButton VBA code to hide/show specific worksheets
    By aprilnparker in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-14-2018, 03:04 PM
  3. VBA code for Checkbox to hide and unhide rows by a specific name
    By NichlasO in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-19-2017, 12:38 PM
  4. [SOLVED] Need code to hide specific rows based on different cell value
    By majzeln in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-04-2016, 02:02 PM
  5. code to hide specific rows
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-23-2016, 11:05 AM
  6. Would like to hide specific text inside macro vba code
    By keisen in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-24-2015, 07:08 PM
  7. [SOLVED] Specific macro or VBA code to hide and unhide rows
    By louvaek in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 11-17-2014, 07:36 AM

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