Excellent, yes. I used both suggestions.
I simply put a CommandButton to HIDE the sheet on the Active sheet being
edited.
Then used a commandbar Popup to access the UnHide / Activate of the sheet.

thanks for replies.
thomas

"bhofsetz" wrote:


Use a combination of the visible property

Sub StartEditing
'Trigger to let user edit sheet
Worksheets("Sheet1").Visible = True
End Sub

'User edits sheet

Sub DoneEditing
'Trigger when user is done editing sheet
Worksheets("Sheet1").Visible = False
End Sub

You'll need some action that the user takes which will trigger the
sheet's visible property to be set to True and then some way to know
when they are done editing the sheet and set the visible property back
to False.

HTH


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=381321