Forum Discussion
Need Help with Error
Hello. I'm hoping someone can help with this error. I'm not sure why this error is occurring because I haven't changed anything in this book regarding Active X Controls and this is happening with multiple files of the same type originated from a template that I've created.
I've attached the screen print of the errors.
These are the steps I've taken to save the file:
Click: File-Save As
Save As window appears
Name file, choose Macro Enabled Workbook
Click Save
Error message appears: Errors were detected while saving...
Click: Continue
Save As window appears
Click: Save
Error message appears: Excel encountered errors during save....
Click: Ok
Repairs to 'file name' box appears
Click: Close
File does not save.
I click Save and the same thing happens.
3 Replies
Could you attach a copy of the template (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar, thank you very much for replying to my post. I apologize for the late reply to you. I wound up figuring out what the issue was. It was in the VBA coding that was causing the error. I opened the file in Safe Mode and fixed the code. Thus far the file is able to be saved without issue. Thank you again for replying. I appreciate you taking your valuable time in assisting. Have a wonder day.
