Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
protecting macro VBA
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Well...
AFAIK protecting the macro by locking the associated project for viewing
should not affect its assigned shortcut key. Well, I'm very confused. In my memory it was the way you say Today I tryed again, it work Like you say But the days before, it did not work (this is why I'm here). Today it's fine. I can not explain why many times it stop going round... If this happend to someone else and he knows where this come from........... thank you... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Well...
Please don't start new threads with your responses!!!
-- Vasant "David C." wrote in message ... AFAIK protecting the macro by locking the associated project for viewing should not affect its assigned shortcut key. Well, I'm very confused. In my memory it was the way you say Today I tryed again, it work Like you say But the days before, it did not work (this is why I'm here). Today it's fine. I can not explain why many times it stop going round... If this happend to someone else and he knows where this come from........... thank you... |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Well...
Please don't start new threads with your responses!!!
I only changed the subject, not the thread... Maybe your reader is not ready for this, but the thread is the same. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Well...
Sorry about that; you are correct.
The general convention is to change the suject line thus: Well... (Was: protecting macro VBA) -- Vasant "David C." wrote in message ... Please don't start new threads with your responses!!! I only changed the subject, not the thread... Maybe your reader is not ready for this, but the thread is the same. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting a macro | Excel Discussion (Misc queries) | |||
Protecting a macro | Excel Discussion (Misc queries) | |||
Protecting a macro | Excel Programming | |||
protecting sheets from a macro | Excel Programming | |||
protecting macro code | Excel Programming |