disable CTRL-pageup & pagedown

[Boss]

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

 

[Kevin B]

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.

 

[Boss]

This way nobody can use the sheet, Actually i have ten users and ten
respective sheets for them.

I have a login page which takes them to therir respective sheet. All i wish
is that one user can only access one sheet.

All the ten sheets are password protected with different passwords. Each
user is aware of his own password. The file is shared.

I have also blocked sheets tabs & freezed tools options using macro. Now i
want to disable Ctrl page up & Page down so that user cannot move to
different sheets.

Hope the situation is more clear. Thanks a lot for help in advance..

Boss

 

[Ron de Bruin]

Maybe you can do this (bug that you can use)

In the worksheets uncheck select locked cells when you protect the sheets
The shortcut is not working then

 

[Gord Dibben]

Using code, you could hide the other sheets when a particular user logs in and
gets taken to his one sheet.

See this google search thread.....

http://tinyurl.com/ysj6dw


Gord Dibben MS Excel MVP