Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros - Unhide and hide
Hi,
I'm a novice at using excel and I'm trying to create a macro that will; When the worksheet is opened, an option can be selected (ticked).....that will unhide all rows that have a certain value in column 'A'. Then when this option is selected on again (unticked), it will hide rows that have a certain value in column 'A'. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros - Unhide and hide
from a post of mine just today. Was it you?
right click sheet tabview codecopy/paste thissave now when you double click any cell in the column it will show that column ONLY until you double click any cell in the visible column again. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If columns("iv").Hidden = True Then columns("a:iv").EntireColumn.Hidden = False Exit Sub Else columns("a:iv").EntireColumn.Hidden = True columns(ActiveCell.Column).EntireColumn.Hidden = False End If End Sub -- Don Guillett SalesAid Software "minka" wrote in message ... Hi, I'm a novice at using excel and I'm trying to create a macro that will; When the worksheet is opened, an option can be selected (ticked).....that will unhide all rows that have a certain value in column 'A'. Then when this option is selected on again (unticked), it will hide rows that have a certain value in column 'A'. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros - Unhide and hide
Don....
Nop..no not me not I. Thnx 4 your speedy reply....I'm really green when it comes 2 macros. I tried your suggestion..but alas, it does nothing...I'm obviously not executing something correctly.. The rows that require to be unhidden and then hidden... have the value in column A that = calendar. This would be facilitated by a box within the worksheet, for which the macro will be assigned once this box is selected, it would unhide all rows that have the value of = calendar in column a. when this box is selected again, it would hide the associated rows. can this be done? anXiously awaiting reply "Don Guillett" wrote: from a post of mine just today. Was it you? right click sheet tabview codecopy/paste thissave now when you double click any cell in the column it will show that column ONLY until you double click any cell in the visible column again. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If columns("iv").Hidden = True Then columns("a:iv").EntireColumn.Hidden = False Exit Sub Else columns("a:iv").EntireColumn.Hidden = True columns(ActiveCell.Column).EntireColumn.Hidden = False End If End Sub -- Don Guillett SalesAid Software "minka" wrote in message ... Hi, I'm a novice at using excel and I'm trying to create a macro that will; When the worksheet is opened, an option can be selected (ticked).....that will unhide all rows that have a certain value in column 'A'. Then when this option is selected on again (unticked), it will hide rows that have a certain value in column 'A'. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to hide and unhide based on criteria | Excel Discussion (Misc queries) | |||
Hide Unhide | Excel Discussion (Misc queries) | |||
How to hide and unhide Rows & Columns | Excel Worksheet Functions | |||
Hide Unhide Hide again | New Users to Excel | |||
Checkbox to hide and unhide rows Please. | Excel Worksheet Functions |