Protecting the formatting in Excel 2007

Protecting the formatting in Excel 2007 I'm creating a number of forms in Excel 2007 for other people to use. They will be accessing the digital versions, and I'm afraid that they'll eventually accidentally break the formatting I've created. The most likely way they'll accidentally break it is by using copy/paste.
Asked by: Guest \| Views: 253

Total answers/comments: 1

Comments display order:

Guest [Entry]

You could make a duplicate (optionally unformatted) sheet which is referenced by your formatted sheet. The formatting of the duplicate data entry sheet doesn't matter, it only provides the values. And you can fully protect the formatted (for printing etc.) version.