it all depends how savvy your users are. personally, mine wouldn't
even begin to know how to unhide a sheet. you can make a sheet hidden
with VBA (below) or using the Format Sheet Hide command from the
toolbar.

activeworkbook.worksheets("sheet1").visible = xlHidden

which can be unhidden using VBA or using the Format Sheet Unhide
command from the toolbar. or you can make a worksheet VERY hidden
(which you can only unhide by VBA or using the VB editor):

activeworkbook.worksheets("sheet1").Visible = xlVeryHidden

if i were you i would use a workbook_open macro to hide xlVeryHidden
all the sheets except the two you have listed until that command
button has been clicked. then, as part of the SameAmendments_click
macro you could unhide the other sheets:

activeworkbook.Worksheets("sheet1").Visible = True

hope i've got it right, and hope it helps you!
:)
susan


On Nov 7, 2:01*pm, "Sandy" wrote:
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