I deliver processed data to my customers via spreadsheet. And, to ensure payment I password protect the data and only release the password once the customer has made payment to PayPal in the appropriate amount.

But the customers often want to see some of the data to judge both its suitability and it's format. So, I copy paste about 10% of the records to a separate workbook and sent it to the customer as a sample. The password protected file is sent at the same time, both as attachments to an email.

I would like to keep the number of spreadsheets I maintain for a project to a minimum. So, I'd like to be able only to send one spreadsheet which contains both a password protected portion and a non-protected portion that the customer can inspect.

Is this possible?

LongFisher