| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to protect recorded macro(s) from being edited by other????
hi,
I would like to protect those created macros in my MS Excel file so that other can't modify them as described below:- when one goes to Tools Macro Macros.....; after he selected a particular macro, once he clicked on the Edit button, a dialog box will pop-up to ask for password. Only those who could enter a valid passward would be allowed to go to the Visual Basic Editor to do the modification. Can the macros being protected in such a way mentioned above??? Anyone out there has any ideal how to do it??? Please advise...................... Thanking in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
| Protect Cell from being edited | Excel Discussion (Misc queries) | |||
| Creating a macro which presses a button containing a recorded macro | Excel Programming | |||
| How do I protect my comments from being edited by another user? | Excel Discussion (Misc queries) | |||
| How to protect a worksheet such that cell value can be edited ? | Excel Programming | |||
Threaded Mode
