You can use the Very Hidden property of the worksheet object to hide the
worksheets from view and then password protect the project.

Open the workbook, press Alt + F11 to open the VB Editor.

On the left there should ba project window and a properties window. Click
the sheet you want to hide and in the Properties Window change the Visible
property to Very Hidden. Repeat for each worksheet you want to hide.

Then right click on the project name at the top of the project window and
select VBAProject Properties, click the Protection tab and assign a password
to the project.
--
Kevin Backmann


"Boss" wrote:

I wish to disable CTRL-pageup & pagedown so that the user cannot swith
between worsheets. I would even wish to hide the Tools-option-sheettabs, so
that user can only work in his worksheet.

Hope what i am lookingf for.. Thanks a lot for help.
Boss