Results 1 to 10 of 10

Vba code to hide specific cells

Threaded View

  1. #10
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,525

    Re: Vba code to hide specific cells

    I propose another solution that does not refer to specific row numbers. It analyzes the colors of the shapes (and cells).
    To use it, you need to "clean up" a bit first by running the ArrangeShapes procedure once. The same macro is assigned to all shapes in the 15:200 row range. You will be able to discard all the modules you have had in the project so far.
    If the category ranges change in the future, just run the ArrangeShapes procedure once again.

    Artik
    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