Hi Chris ,
Can you please clarify one point ?
Do the hidden sheets become visible when you just save the workbook , or when you close ( with a save ) and reopen ?
If it is the former , we need to look at the code within these procedures :
Call Solve_Carry_Costs
Call prCust_WbBeforeSave(SaveAsUI, Cancel)
If it is the latter , we need to look at the code within these procedures :
Call Solve_Carry_Costs
Call prCust_WbBeforeClose(Cancel)
Call prCust_WbOpen
However , the easiest way to decide whether it is the code which is doing it , or Excel itself , is to rename the event procedures by just adding the suffix 1 , as in :
Private Sub Workbook_BeforeSave1(ByVal SaveAsUI As Boolean, Cancel As Boolean)
This ensures that no code will be executed when you do a manual Save ; if the problem does not occur , it is very clear that it is the code within the event procedure which is causing it.
Narayan