I have two worksheets, namely "Current Round" and "Current Round Detailed"
along with 6 others that are visible. What I would like to do is contain the
user to the two sheets above until a command button has been clicked.

The command button is "SaveAmendments", and becomes hidden once the attached
code is run.

I suppose the layman's way would be something like


If Worksheets("Current Round").Buttons("SaveAmendment").Visible = True Then

Disable moving to any sheet other than "Current Round" and "Current
Round Detailed" (or maybe better to just hide the other sheets?)
Prevent user closing application

End If

Your thoughts on the above are appreciated
Sandy