Thread: mac problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
libby libby is offline
external usenet poster
 
Posts: 96
Default mac problem

Hi
Any ideas as to why the following code doesn't work when
run on a mac?

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean,
Cancel As Boolean)
If Sheet12.Range("g4") < Date Or _
Sheet121.Range("g4") < Date Then
Select Case MsgBox("Dates have not been updated!" &
vbCr & "Do you want to update Dates?", vbQuestion +
vbYesNoCancel)
Case vbYes
Sheet12.Range("g4") = Date
Sheet121.Range("g4") = Date
Case vbNo
MsgBox ThisWorkbook.Name & " will be saved without
updating Dates.", vbInformation
Case vbCancel
Cancel = True
MsgBox "Save cancelled!", vbExclamation
End Select
End If
End Sub