Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Protecting Macro's
Ive created some macro's using the macro wizard on excel. Im trying to protect the worksheet from being amended. In the work sheet the macro transfers the data to another sheet using the paste special link. I save the macro and then protect the worksheet. If I use the macro by going into tools-macro's etc it works fine. I now tried to put the macro into a link box which is also on a protected sheet. Ive unprotected the sheet and used assign a macro and saved it and re protected. Once I done that the macro funs fine but does not transfer the figures over. Can anyone help?? -- shrek |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect macros? | Excel Discussion (Misc queries) | |||
Saving Macros | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
Protecting My Macros | Excel Worksheet Functions |