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.
Protect and Copy
- John Hobson
- Site Admin
- Posts: 330
- Joined: Sun May 11, 2008 4:58 pm
- OLAP Product: Any
- Version: 1.0
- Excel Version: 2020
- Location: Lytham UK
- Contact:
Protect and Copy
- Attachments
-
- TPF Palo Protected Sheet v1.2b.zip
- Palo Protect and Copy code
- (34.55 KiB) Downloaded 576 times
John Hobson
The Planning Factory
The Planning Factory