Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ctrl + Pagedown lock | Excel Discussion (Misc queries) | |||
Why doesn't active cell move using PageDown key in Excel 2007? | Excel Discussion (Misc queries) | |||
How to forbid ctrl+c and ctrl+X in sheet? | Setting up and Configuration of Excel | |||
Why does'nt sheet protection allow CTRL+PAGEUP/DOWN to work? | Excel Worksheet Functions | |||
Disable CTRL+D??? | Excel Discussion (Misc queries) |