Hi All,

Can Someone please help me? I have a button with the following macro to hide/show rows:

Sub HideUnhide()
Rows("165:183").Hidden = Not Rows("165:183").Hidden
End Sub

This works perfectly for hiding/showing these rows by clicking on the button. The problem I have is that I would like to Hide rows 4:157 when the button shows rows 165:183, and show rows 4:157 when button hides rows 165:183.

Is this possible, and if so, can anyone please assist me?

Also, how can I create a button which shows a specific sheet in the workbook, but the user must not be able to unhide the sheet. It can only be done by making use of the button?

I will appreciate any help if possible. Thank you so much in advance.