Protect and Copy
Posted: Thu May 15, 2008 8:03 am
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.
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.