Forum Discussion
Macro enabled workbooks wont open in Excel 2016
Hi Peter,
I included the changed workbooks in the zip file here. Of, course please also check the repaired versions for loss of functionality.
Note to forum moderator: I firstly tried to upload a zip file having a dot in its name, e.g. workbooks.repaired.zip. This forum then shows me the error "The contents of the attachment doesn't match its file type."
Best,
Mourad
Hello Peter,
without seeing the code, it's I think difficult to delimit the error. May be, if you disable the Splash Screen, it could in a first step help. I guess, the Splash Screen is a UserForm, e.g. frmSplash. Search for the the UserForm name in the code and comment it out by putting a ' in front of the statement like frmSplash.Show. If the splash starts on opening, the statement may be in the ThisWorkbook code module. After disabling the splash screen test the file again. Does the rest then work?
Best,
Mourad
I reviewed this post as I am having issues opening a macro enabled workbook in excel 2016. My issue is I created this workbook using excel 2016. I'll put in the VBA code and everything will work fine. When I save it I receive a prompt for macro enabled workbook and I change the file type to do so, but once I close out of the file and re-open it, the VBA codes do not work properly. As an example, I created a drop down list with multiple selections. It will work when I put the code in, but once I save and re-open I cannot make multiple selections from the drop down list.