Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel Shortcut Key
To all the guru's out there,
Is there a way at all possible for me to disable shortcut keys within a worksheet in excel, also im not sure if its under excel options, but is there a way i can stop a user from clicking on a worksheet e.g. a worksheet full of graphs a user cannot select a cell, or a cell wouldnt be selected? Many thanks for your responses. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Shortcut Key
smiling_smiler brought next idea :
To all the guru's out there, Is there a way at all possible for me to disable shortcut keys within a worksheet in excel, also im not sure if its under excel options, but is there a way i can stop a user from clicking on a worksheet e.g. a worksheet full of graphs a user cannot select a cell, or a cell wouldnt be selected? Many thanks for your responses. You can protect the sheet and allow users to only select unlocked cells. Of course, all the cells will need to be locked to prevent user selecting anything. You can disable/enable keyboard shortcuts via VBA in sheet event handlers so they toggle off/on as the target sheet is activated/deactivated. I accomplish this in my dictator apps by storing the shortcuts in a string constant that I load into an array and iterating it as needed. Please provide a list of the shortcuts you want to disable/enable and I'll see what I can do toward providing a reusable function for this. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
shortcut has change or move so this shortcut can not open | Excel Worksheet Functions | |||
Excel Shortcut | Excel Discussion (Misc queries) | |||
Excel Shortcut | New Users to Excel | |||
Macro Shortcut Key Conflicts with Application Shortcut Keys | Excel Programming | |||
Macro Shortcut Key Conflicts with Application Shortcut Keys | Excel Programming |