View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Greg is offline
external usenet poster
 
Posts: 331
Default Disabling Macros

I have a workbook (with several worksheets). One of the worksheets just
contains information explaining the use and functionality of the workbook.
How can I stop a user from trying to run the macro when the informational
sheet is active? MY first attempt was to create a private sub on the
worksheet and use Application.OnKey and trap the macro's I do not want the
user to run. Excel blew up and abended abnormally.