hide/unhide macro

Z

zenahs

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
 
B

Bob Phillips

Sub HideUnhide
Rows("10:11").Hidden = Not Rows("10:11").Hidden
End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
P

PCLIVE

Sub HideUnhideRow()
If Range("A1").EntireRow.Hidden = True Then Range("A1").EntireRow.Hidden =
False Else: Range("A1").EntireRow.Hidden = True
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide and Unhide Rows button 6
Hide, unhide macro 19
peculiar condition: form optionbuttons lose position and linkedcellon row hide 1
VB Code to hide rows 3
Hide and Unhide 3
Macro to Unhide Rows 3
Hide / Unhide Columns in Password Protected w/s 2
Change macro button text when macro is invoked. 2

Top