Protecting Macro's
shrek Wrote: 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?? Ive tried putting the protect/unprotect on the macro and it still asks me for the password. -- shrek |
All times are GMT +1. The time now is 11:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com