how to hide and unhide rows using 2 buttons

Eerised

New Member
Joined
Apr 12, 2013
Messages
1
I need help..

i have 2 buttons "Calendar Period and Accounting Period, i use the code below to hide the Accounting Period

Private Sub Calendar_Period_Click()
Dim myRng As Range


Set myRng = Me.Range("a21:g32")


myRng.EntireRow.Hidden = Not (myRng(1).EntireRow.Hidden)


End Sub

can you please help me on how to code if i click on the Accounting Period button; the Calendar Rows will hide and will unhide the Accounting Period columns.

thanks
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Forum statistics

Threads
1,203,501
Messages
6,055,765
Members
444,821
Latest member
Shameer

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top