View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default private macro and shortcut key

Since it is private to your project/workbook/module, then the application
can not see the procedure.

--
Regards,
Tom Ogilvy


"redb" wrote in message
...
Is it possible to have a keyboard shortcut for a macro that is designated
Private? I have created a macro and given it a keyboard shortcut. The

macro
works perfectly, until I made it "Private Sub Macro." Any ideas why this
doesn't work?

Thanks!