View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default protecting macro VBA

AFAIK protecting the macro by locking the associated project for viewing
should not affect its assigned shortcut key.

--

Vasant

"David C." wrote in message
...
Hello,

I would like to protect my VBA macro from being read or changed by users

of
my excel workbook.
Of course, I first tryed the project VBA protection (option menu)

But the point is that...
this also stop the shortcut keys (CTRL+....) on macro

I would like to call some macro with CTRL keys, and still protect the

code.

How to do this ?
thank you...

--
David C.