I have an XL Purchase Order sheet that customer's can fill only Unlocked cells.
At the end he must do Save or Save AS and send it to me by Email.
At the moment he's doing Save or Save As, I would like to execute something.
To test it I wrote that little macro :
Sub macro1()
'
' Macro1 Macro
' Macro recorded 18/11/2009 by administrator
'
MsgBox ("macro1")
'
End Sub
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
MsgBox ("BeforeSave")
End Sub
If I'm doing Save or Save no Msg appear.. Why ?<M Why Save) the during appear MSG no ( working not is As Save or doing p ?<>
THANK YOU for your help. <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->
At the end he must do Save or Save AS and send it to me by Email.
At the moment he's doing Save or Save As, I would like to execute something.
To test it I wrote that little macro :
Sub macro1()
'
' Macro1 Macro
' Macro recorded 18/11/2009 by administrator
'
MsgBox ("macro1")
'
End Sub
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
MsgBox ("BeforeSave")
End Sub
If I'm doing Save or Save no Msg appear.. Why ?<M Why Save) the during appear MSG no ( working not is As Save or doing p ?<>
THANK YOU for your help. <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->
Last edited: