View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Per[_2_] Per[_2_] is offline
external usenet poster
 
Posts: 10
Default Worksheet_BeforeClose conditional Worksheet change

Trying to make the following macro dependant on any change in the active
worksheet. In other words it should not be inaugerated if the the file just
is opened for view or printing, but only when any cell in the sheet is
changed. Can worksheet change be used? Does anybody have a solution?

Sub Workbook_BeforeClose(cancel As Boolean)
If Sheets("INKÖP").Range("C3").Value Range("C2") Then
If MsgBox("Revisionsdatum ej uppdaterat! Uppdatera nu?", _
vbCritical + vbYesNo, _
"OBS! revisionsdatum") = vbYes Then cancel = True
End If
End Sub

--
PerNorman