We have a few macros running on our Excel system in our company which are very critical for us. Unfortunately, today all the macros stopped working. I am getting an error called 1004. I have all my macros enables and everything is the same as what we`ve been having for the past few months. I don`t know why they stopped working today. The error says:
Cannot run the macro XXX. The macro may not be available in this workbook or all macros may be disabled.
The macros are on main a file on the server and they are being called from a local file on each computer in our company. We have had this for so long and it`s been working properly. Not sure what happened?
Private Sub Setup_Data_Click() Application.Run ("'Y:\Main.xlsm'!Data_SetupMacro") Workbooks(Dir("Y:\Main.xlsm")).Close Savechanges:=False End Sub