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.
Bookmarks