When you save a workbook, you save all the sheets in that workbook.

So you want to delete the other sheets before the workbook is saved, right?

Well, the problem with that is that you can't delete sheets from a shared
workbook.

So maybe you could provide a macro that would:
unshare the workbook
delete the sheets
share the workbook
and then save this workbook.

You could record a macro when you do this manually and you'll have the code.



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?

--

Dave Peterson