+ Reply to Thread
Results 1 to 4 of 4

Hiding rows in protected document using check box as "trigger".

  1. #1
    Registered User
    Join Date
    06-15-2010
    Location
    michigan
    MS-Off Ver
    Excel 2013
    Posts
    31

    Hiding rows in protected document using check box as "trigger".

    Hello All:

    I'm having difficulty in a protected document (protect sheet) for a macro to run that would allow for hidden rows to become visible for data entry and keep document protected once rows are visible. Macro needs to be initiated by a check box.

    Also,

    Once check box is "deselected" the same rows need to become hidden once again without loosing data contained within those hidden rows.

    Please see attached document for more clarity.


    Thank you in advance for your help.
    Attached Files Attached Files

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: Hiding rows in protected document using check box as "trigger".

    Hi there,

    See if the attached version of your workbook does what you need. It uses the following code:

    Please Login or Register  to view this content.
    The highlighted values can be changed to suit your own requirements.


    Hope this helps - please let me know how you get on.

    Regards,

    Greg M
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-15-2010
    Location
    michigan
    MS-Off Ver
    Excel 2013
    Posts
    31

    Re: Hiding rows in protected document using check box as "trigger".

    Greg : It appears to do exactly what I was hoping for! Thank you so much for your efforts.

    Where did you place code within document? I'm trying to locate it in "Developer - Macros" and can't see it? And how did you assign it to check box?

    I intend to duplicate this process in a few different sheets within document, and I'm not sure I understand how you managed to link to check box and where you have it in document?

    Thank you so much, it appears to be just what I was trying to accomplish !

    Harold

  4. #4
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: Hiding rows in protected document using check box as "trigger".

    Hi again Harold,

    Many thanks for your feedback.

    You're welcome - glad I was able to help.

    You'll be able to view the code by entering the VBA Editor (Alt+F11) and clicking on the Modules folder in the treeview there.

    To assign the routine to a CheckBox on a worksheet just right-click on the CheckBox and select Assign Macro from the dropdown list.

    Hope this helps - as before, please let me know how you get on.

    Regards,

    Greg M

+ 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. Replies: 35
    Last Post: 01-13-2016, 02:16 AM
  2. [SOLVED] Need help with this code for hiding rows with "0"
    By duvius in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-03-2014, 05:51 PM
  3. Replies: 5
    Last Post: 01-23-2014, 11:02 AM
  4. Excel 2007 : "Inspect Document" misses hidden rows
    By beng404 in forum Excel General
    Replies: 1
    Last Post: 06-26-2012, 02:50 PM
  5. Hiding Rows With A Cell Containing "0"
    By ExcelBob in forum Excel General
    Replies: 10
    Last Post: 04-23-2008, 01:07 PM
  6. [SOLVED] create links to check boxes marked "good" fair"and "bad"
    By pjb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-19-2006, 09:25 PM
  7. hiding/unhiding rows & columns with "+" and "-" buttons
    By shellshock in forum Excel General
    Replies: 2
    Last Post: 08-03-2005, 01:05 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