I have seen many answers on this but unfortunately I cannot find the fault.
I automatically open a workbook when Excel opens, using Option, Advanced, General, at startup open all file in etc...
Then in the ThisWorkbook Object I have inserted:
Private Sub Auto_Open()
The "RunMacros" macro is inserted in Module1
If I browse through using F8, the Auto_Open macro works but it does not work automatically on opening.