Hello,
Is there is simple and elegant way to do the following?
Workbook A is the main macro based workbook which saves info onto workbook B. Looking for simple code to save the info in workbook B only if workbook B is editable, if workbook B is readonly then message code should pop up saying "Unable to save work, retry?"
"No" should = exit sub and "yes" should retry opening in editable format and proceed with code.
Thank you.
Bookmarks