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
.
|