Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello Below is the code for a command button I Have. I have sevaral of
these command buttons in the file. Private Sub CommandButton1_Click() Dim myRng As Range Set myRng = Me.Range("a36:V70") myRng.EntireRow.Hidden = Not (myRng(1).EntireRow.Hidden) To this command button I want to add another command which is if Cell A 70 = Non-Standard (this is from a drop down list) then unhide rows 71 thru 79. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
VBA Command Button | Excel Discussion (Misc queries) | |||
Command Button | Excel Worksheet Functions | |||
Using a command button to add | Excel Discussion (Misc queries) | |||
Command button | New Users to Excel |