Hi there!
I have a document with two buttons:
1. "Edit Discount"
2. "Stop Editing and Recalculate"
What I want to happen is for the sheet to be protected when the user first accesses it and only the "Edit Discount" button visible. When the user clicks the button, the sheet is unprotected and the "Stop Editing and Recalcuate" button becomes visible. After the user makes any necessary changes while the sheet is unprotected, they can then click "Stop Editing and Recalculate." After clicking that button, it will recalculate and the sheet will be protected and only the "Edit Discount" button visible.
I've been able to do most of this, but the part that I keep struggling with is the visibility of the button. At the end of the macro in the "Edit Discount" button it says:
If Worksheets("Quote Summary").Unprotect = True Then
ActiveSheet.Buttons("Button 17").Visible = False
Else
ActiveSheet.Buttons("Button 17").Visible = True
End If
I have a document with two buttons:
1. "Edit Discount"
2. "Stop Editing and Recalculate"
What I want to happen is for the sheet to be protected when the user first accesses it and only the "Edit Discount" button visible. When the user clicks the button, the sheet is unprotected and the "Stop Editing and Recalcuate" button becomes visible. After the user makes any necessary changes while the sheet is unprotected, they can then click "Stop Editing and Recalculate." After clicking that button, it will recalculate and the sheet will be protected and only the "Edit Discount" button visible.
I've been able to do most of this, but the part that I keep struggling with is the visibility of the button. At the end of the macro in the "Edit Discount" button it says:
If Worksheets("Quote Summary").Unprotect = True Then
ActiveSheet.Buttons("Button 17").Visible = False
Else
ActiveSheet.Buttons("Button 17").Visible = True
End If