View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default Protect selected settings in 'options'

Shane Devenshire wrote...
When you do hide these features you aren't preventing the user from using
the keyboard to navigate within a sheet and there are many ways to go from
sheet to sheet other than clicking the tabs. . . .

....

Could use OnKey method calls to map [Ctrl]+[PgUp] and [Ctrl]+[PgDn] to
do-nothing macros, which would effectively disable them. Same caveat
as I mentioned previously: requires macros to do this, so could be
disabled by opening the workbook with macros disabled. OTOH, opening
the workbook in an Excel Automation session driven by an outside
application could ensure that the necessary OnKey method calls were
run.

So if an outside application has disabled all cursor keys and the [F5]
key, hidden the worksheet tabs, and hidden the standard menu, how
could a user move between worksheets?