| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lock macro's from being edited
Hi. I have recorded a few macros and attached them to an object in Excel. I
need to leave one worksheet unlocked so that users can paste data in the "Working" tab before clicking on the object to run the required macro. I want to stop users from being able to access the macro though - via Tools, Macro, Macros... - as someone has tried this without understanding the macro, and it has been corrupted. Any ideas? I'm using version 2000 if it makes any difference... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Lock macro's from being edited
Hi,
Try:- Alt+F11 Tools|VBA Project Properties|Protection Check 'Lock project for viewing' and apply a password. Mike "Tinkerbell.1178" wrote: Hi. I have recorded a few macros and attached them to an object in Excel. I need to leave one worksheet unlocked so that users can paste data in the "Working" tab before clicking on the object to run the required macro. I want to stop users from being able to access the macro though - via Tools, Macro, Macros... - as someone has tried this without understanding the macro, and it has been corrupted. Any ideas? I'm using version 2000 if it makes any difference... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I lock certain cells from getting edited | New Users to Excel | |||
| Macro's | Excel Discussion (Misc queries) | |||
| Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
| Macro's | Excel Worksheet Functions | |||
| Am I asking too much of my macro's | Excel Discussion (Misc queries) | |||
Linear Mode
