+ Reply to Thread
Results 1 to 2 of 2

Multiple Worksheet Events in same excel

  1. #1
    Registered User
    Join Date
    08-17-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Multiple Worksheet Events in same excel

    Hi,

    I have below code to hide the Rows 25 to 28 based on the selection in the Cell E24(Like If ,

    Code:
    Private Sub Worksheet_Change(ByVal Target As Range)
    If Intersect(Target, Range("E24")) Is Nothing Then Exit Sub

    Select Case Target.Value
    Case "No"
    Rows("25:28").EntireRow.Hidden = True

    Case "Yes"
    Rows("25:28").EntireRow.Hidden = False
    End Select
    End Sub

    However my requirement is to apply this same logic in many rows in the same excel sheet.Eg. In place of E30 is "Yes" then Rows from 31 to 38 to be hide,E49 is "Yes", then Rows 50 to 60 to be hide and so on at many Rows inn same excel.

    Can anyone help on this at the earliest.

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,102

    Re: Multiple Worksheet Events in same excel

    I implemented a similar solution in this forum. let us know if you have questions.

+ 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. Multiple Worksheet Change Events - Excel VBA
    By Starite in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2017, 04:19 AM
  2. [SOLVED] VBA help - multiple worksheet change events
    By tbear1997 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-08-2016, 03:51 PM
  3. VBA Multiple Worksheet Change Events
    By Zimbo in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-24-2013, 10:58 AM
  4. Multiple Worksheet Change Events
    By justinharris in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2011, 06:11 PM
  5. Multiple Worksheet Change Events
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 12-13-2010, 06:14 PM
  6. Worksheet Multiple Change Events
    By max57 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-24-2010, 02:02 AM
  7. Multiple Worksheet Change Events???
    By Potoroo in forum Excel General
    Replies: 3
    Last Post: 11-28-2006, 12:59 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