Figured out the issue. Although the variables being used in the
StartProgram module were initiated perfectly fine, the values being
assigned to them via the "Sub StartSetColumns()" were not infact not
being assigned. This is because this sub should have been running at
everytime the workbook opens however the code for it was not in the
ThisWorkbook object which can be found via the VBE. The code was
either missed or not copied over from the pervious version of this
document. Below is that code just for completness sake. Thank you
for you help.

Private Sub Workbook_Open()
Application.ScreenUpdating = False
Call ShowAllSheets
Call StartSetColumns
Call DisableCopyCutAndPaste
Call FirstSheet
Application.ScreenUpdating = True
End Sub


Kind regards