https://github.com/jamesorr/CO2SYS-Excel
Raw File
Tip revision: 202775e99f55d4d837a24b3c565632dafa0ca156 authored by James Orr on 15 February 2021, 12:59:05 UTC
inserted "Ptrsafe" into "Declare Function" - 64bit
Tip revision: 202775e
ThisWorkBook.bas


Option Base 1



Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    If SaveAsUI = False Then
          answer = InputBox("Please, use ""Save As..."" instead.")
          If (answer <> "1967") Then
                Cancel = True
          Else
                Cancel = False
          End If
    End If
End Sub

Private Sub Workbook_Open()
        
        InitiateOK = False
        Call Initiate(True)
        Sheets("INPUT").Activate
End Sub




back to top