Thread: Save ONLY 1 Sheet in a Shared Workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] truapplegirl@gmail.com is offline
external usenet poster
  
Posts: 1
Default Save ONLY 1 Sheet in a Shared Workbook
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?
Reply With QuoteReply With Quote