Results 1 to 12 of 12

Automatically hide/unhide rows based on cell value

Threaded View

  1. #5
    Registered User
    Join Date
    07-28-2014
    Location
    Perth, Australia
    MS-Off Ver
    2019
    Posts
    31

    Re: Automatically hide/unhide rows based on cell value

    Hello again,

    As I have been playing with the file I noticed two things which I'm wondering if they could be adjusted.

    1) the hide/unhide does not allow row 80 to unhide... it stops at 79.
    2) when I try to protect each sheet (so people cannot mess with the formulas) there is an error and it cannot hide or unhide the protected rows.

    Is there anything which can be done to solve these?

    Please see the new reference file attached.

    Thank you!
    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] Automatically hide and unhide rows based on selected month
    By dondonordas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2018, 02:07 AM
  2. Automatically hide/unhide rows based on column A value
    By c.bernardo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-14-2017, 12:30 AM
  3. How to automatically hide/unhide exact number of rows based on a cell's value
    By masud_jahan in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-27-2016, 05:23 AM
  4. Automatically hide and unhide rows based on value in cell
    By kmham in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-28-2014, 12:03 PM
  5. [SOLVED] Macro to Automatically Hide/Unhide Rows Based on Checkbox
    By bga10s in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-27-2014, 07:32 PM
  6. [SOLVED] Macro to automatically hide or unhide rows based on either a value or no value in a cell
    By WFP111 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-04-2013, 12:28 PM
  7. How Do I Hide/Unhide Rows in Excel based on a cell Value Automatically?
    By mgarcia in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-06-2012, 05:20 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