Protect sheet but allow insert macro.

Hello all,

And thank you for all the top advice I have received.

I have a need to protect my worksheets but they are useless unless I am still able to use an insert cells macro I have written. I've tried allowing all of the protect sheet options but it seems if it is protected in any way this macro wont work.

Has anyone got any ideas about this?

Here is the code for your reference (essentially it finds a range, copies then inserts it to the top of a table)

Please Login or Register  to view this content.

Thanks

Ah, of course.

Thank you very much Pierre!