+ Reply to Thread
Results 1 to 2 of 2

Enable/Disable vba code

  1. #1
    Registered User
    Join Date
    03-06-2015
    Location
    Rotterdam, The Netherlands
    MS-Off Ver
    2013
    Posts
    22

    Thumbs up Enable/Disable vba code

    I use the following code to hide rows which contain a specific value in a cell.
    In the code below the row will be hidden when the value 1 is placed in any row in column E.

    This is exactly what I need, although I want to have the option to hide and unhide the rows.
    For example when entering a specific value in another cell like: in A1 the word hide or unhide to hide or show all rows.

    How do I extend the script below to achieve this ?

    Please Login or Register  to view this content.
    Last edited by henk400; 04-02-2015 at 08:34 AM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,104

    Re: Enable/Disable vba code

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Never use Merged Cells in Excel

+ 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. [SOLVED] Code to disable and enable indentations
    By kosherboy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2014, 01:38 PM
  2. Create A Button In Document To Disable/Enable A Specific Line of Code
    By BLK306 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-05-2014, 02:12 PM
  3. Enable/disable copy paste (disable part not working)
    By timtim89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2012, 07:23 PM
  4. Enable and disable
    By rajeev.raj in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-10-2010, 02:50 AM
  5. Enable / Disable CD-ROM thru VB
    By Lochdanon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-02-2009, 10:43 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