Protect and Copy

[John Hobson]

Here is a bit of VBA code that does a similar job to the TM1 copy module that was posted on the old forum a while back by Dan Bernatchez of Revelwood.

It uses the format style that PALO uses for its Paste Data function to determine the protected area so it's a bit simpler in operation (you don't have to set protection like in the TM1 implementation). It also disables as much cut / copy / delete stuff for the open workbook as I could make it do.

I also has a copy routine that allows you to copy data over PALO.DATA cells.

Any ideas for improvements gratefully received.