+ Reply to Thread
Results 1 to 1 of 1

Macro/VBA - Hide/unhide rows in sheet through YES/NO Controll

  1. #1
    Registered User
    Join Date
    03-18-2005
    Posts
    36

    Macro/VBA - Hide/unhide rows in sheet through YES/NO Controll

    Hey all,

    Can anybody tell me how I can hide and unhide rows in a excel sheet through a action bar pull-down - with the index option "Yes" and "No" (Hide "yes" and "no" for unhide rows).

    This is what I have so far:
    Sub HideUnhide_rows()
    '
    ' HideUnhide_rows Makro
    ' Makro registrert 19.03.2005 av Aage
    '

    '
    Rows("19:21").Select
    Range("A21").Activate
    Selection.EntireRow.Hidden = True
    Range("F5:L5").Select
    End Sub

    Only one of the two options work through this, so please help me with the final bit..

    Thanks,

    Age
    Last edited by age; 03-18-2005 at 09:17 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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