I modified your workbook slightly, added some code and a couple of buttons from the Forms toolbar. I believe it does what you want.
- Insert a row just above "auction items", call it Details and format it
- the same as the Summary row.
- Clear the outline
- Add a button to cell B25 with the caption "Details"
- Add a button to cell C25 with the caption "Summary"
- Add a module to your workbook and insert the following code
Code:
Sub ShowTheDetails()
ActiveSheet.Unprotect
If Rows(27).Hidden = True Then
Rows("27:43").Hidden = False
Else
Rows("27:43").Hidden = True
End If
ActiveSheet.Protect
End Sub
Sub ShowTheSummary()
ActiveSheet.Unprotect
If Rows(45).Hidden = True Then
Rows("45:53").Hidden = False
Else
Rows("45:53").Hidden = True
End If
ActiveSheet.Protect
End Sub
7. Assign ShowTheDetails macro to the "Details" button.
8. Assign ShowTheSummary macro to the "Summary button.
I will be glad to send you the workbook with the changes in it, if you would like to see it.
Bookmarks