Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide/unhide macro
Can someone help me design a hide/unhide macro that I can attach to a button? I'm looking to create a macro that will allow me to hide the contents of two specific cells (or rows if need be) at the click of a button...and then unhide them again at the click of the same button. So far, I've been successful at hiding these two rows at the click of a button but not unhide them. Here's what I had so far: ActiveWindow.SmallScroll Down:=50 Range("C66:M67,C75:M76").Select Range("C75").Activate Selection.EntireRow.Hidden = True End Sub Thank you -- zenahs ------------------------------------------------------------------------ zenahs's Profile: http://www.excelforum.com/member.php...o&userid=28681 View this thread: http://www.excelforum.com/showthread...hreadid=484013 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide/unhide macro
Sub HideUnhide
Rows("10:11").Hidden = Not Rows("10:11").Hidden End Sub -- HTH RP (remove nothere from the email address if mailing direct) "zenahs" wrote in message ... Can someone help me design a hide/unhide macro that I can attach to a button? I'm looking to create a macro that will allow me to hide the contents of two specific cells (or rows if need be) at the click of a button...and then unhide them again at the click of the same button. So far, I've been successful at hiding these two rows at the click of a button but not unhide them. Here's what I had so far: ActiveWindow.SmallScroll Down:=50 Range("C66:M67,C75:M76").Select Range("C75").Activate Selection.EntireRow.Hidden = True End Sub Thank you -- zenahs ------------------------------------------------------------------------ zenahs's Profile: http://www.excelforum.com/member.php...o&userid=28681 View this thread: http://www.excelforum.com/showthread...hreadid=484013 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide/unhide macro
Sub HideUnhideRow()
If Range("A1").EntireRow.Hidden = True Then Range("A1").EntireRow.Hidden = False Else: Range("A1").EntireRow.Hidden = True End Sub "zenahs" wrote in message ... Can someone help me design a hide/unhide macro that I can attach to a button? I'm looking to create a macro that will allow me to hide the contents of two specific cells (or rows if need be) at the click of a button...and then unhide them again at the click of the same button. So far, I've been successful at hiding these two rows at the click of a button but not unhide them. Here's what I had so far: ActiveWindow.SmallScroll Down:=50 Range("C66:M67,C75:M76").Select Range("C75").Activate Selection.EntireRow.Hidden = True End Sub Thank you -- zenahs ------------------------------------------------------------------------ zenahs's Profile: http://www.excelforum.com/member.php...o&userid=28681 View this thread: http://www.excelforum.com/showthread...hreadid=484013 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro that will unhide then hide rows | Excel Discussion (Misc queries) | |||
hide/unhide macro | Excel Discussion (Misc queries) | |||
Macro to hide or unhide columns | Excel Programming | |||
Macro that will always hide / unhide next column | Excel Programming | |||
Hide/Unhide Macro bug | Excel Programming |