https://github.com/jamesorr/CO2SYS-Excel
Tip revision: 202775e99f55d4d837a24b3c565632dafa0ca156 authored by James Orr on 15 February 2021, 12:59:05 UTC
inserted "Ptrsafe" into "Declare Function" - 64bit
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