Thread: How to disable VIEW CODE in the tab of a workbook
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default How to disable VIEW CODE in the tab of a workbook
One way:

Application.OnKey "%{F11}",""

though, since nearly all shortcut keys are fully customizable (at least
in MacXL), there's no guarantee that this is the, or the only, keyboard
shortcut for viewing macros.


In article ,
"Martyn" wrote:

And can you please share your knowledge, how have you been able to disable
the shortcut keys for viewing macros?
Reply With QuoteReply With Quote