I believe it will allow you to clear contents of sheets AA and BB and then
you could save the entire workbook with only sheet CC containing data, but
then you lose any formulas you had in sheets AA and BB.

Or as Dave suggested, unshare the workbook, then do a worksheets("CC").Copy
without specifying the before or after and it creates a new workbook which
you can then do a saveas on, the reshare the original workbook. This could
all be done with code external to the shared workbook.

" wrote:

I have 3 sheets within my shared workbook: SheetAA, SheetBB, SheetCC
I ONLY want to allow the contents of "SheetCC" to save when the SAVE
button is clicked OR the sheet is closed.

How can I code this in VB, and where should codes be placed?