ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   disable CTRL-pageup & pagedown (https://www.excelbanter.com/excel-discussion-misc-queries/172074-disable-ctrl-pageup-pagedown.html)

BOSS

disable CTRL-pageup & pagedown
 
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

disable CTRL-pageup & pagedown
 
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


BOSS

disable CTRL-pageup & pagedown
 
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


"Kevin B" wrote:

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


Ron de Bruin

disable CTRL-pageup & pagedown
 
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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Boss" wrote in message ...
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


"Kevin B" wrote:

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


Gord Dibben

disable CTRL-pageup & pagedown
 
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

On Tue, 8 Jan 2008 05:35:01 -0800, Boss wrote:

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


"Kevin B" wrote:

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




All times are GMT +1. The time now is 02:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com