View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
 
Posts: 535
Default A save question:

Hi,

For that specific workbook, use its Before_save event in
the thisworkbook module:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean,
Cancel As Boolean)
if msgbox("Save ?",vbYesNo)=vbNo then
Msgbox "I'm not saving myself!!"
Cancel=True
Else
msgbox "Saving!!"
end if
End Sub

Regards,

Jan Karel Pieterse
Excel TA/MVP

-----Original Message-----
Is there a way to attach a macro to the Excel save button
and have it work exclusively for an uniquely identified
workbook, but operate normally otherwise.

Or is the answer to put a save button (control) on each
worksheet?

Thanks,
Phil
.