@Dan Elgaard
Nu tror jeg jeg fik nogenlunde overblik over det du foreslog...
Ud fra det har jeg nu følgende kode, placeret øverst i et modul
Option Explicit
Public AutoRunForecast As Boolean ' declaire my variable
Sub SettingsFunctions()
' Initialize
AutoRunForecast = GetSetting("FolmerJensenFOLJ", "FermPlanValues", "AutoRunForecast", True) ' Get previous saved value
Dim MsgBoxText As String
MsgBoxText = "Current value in AutoRunForecast is: " & AutoRunForecast & vbNewLine
'
' Request value from user
If MsgBox(MsgBoxText, vbYesNo + vbQuestion) = vbYes Then
MsgBox "Writing to forecast file will continue"
WriteDataToDraftSheet
End If
' Save value for usage in other files...
SaveSetting "FolmerJensenFOLJ", "FermPlanValues", "AutoRunForecast", True ' Save value to Registry
' when we dont need yhe AutoRunForecast-value any more...
If AutoRunForecast = True Then
On Error Resume Next ' To avoid error, if key doesn't exists
DeleteSetting "FolmerJensenFOLJ", "FermPlanValues", "AutoRunForecast" ' Delete value from Registry
DeleteSetting "FolmerJensenFOLJ", "FermPlanValues" ' Delete section from Registry
DeleteSetting "FolmerJensenFOLJ" ' Delete application key from Registry
End If
End Sub
Men næste skridt, hvor jeg disabler linierne DeleteSetting, og tester i en anden fil om der er en tilgængelig variabel der hedder
If AutoRunForecast = True Then
så er svaret nej.