How to hide the particular row when a button is clicked using macros

[kailashramuu]

Hi,

How to hide the particular rows in a sheet when the button is clicked using macros....



Can anyone help me on this,....


Regards
Kailash

 

[klarowe]

Are you trying to hide particular data or particular rows. If you just hide the row then if anyone inserts/deletes a row above the row that you hide, that data will no longer be hidden.
However if you highlight the actual data you want to hide (keeping in mind that the entire row will still be hidden) and define that particular range (insert - Name - Define) then you can hide it using:

Sheets("Sheet_Name").Range("Name_of_Range").EntireRow.Hidden = Sheets("Sheet_Name").Togglebutton1.value (if using a toggle button)

Otherwise if you just want the row hidden its:

Sheets("Sheet_Name").Range("1:2").EntireRow.Hidden = Sheets("Sheet_Name").Togglebutton1.Value