My instructions are to - protect the shared workbook - make a copy of the shared workbook - edit copied workbook -close copy - merge workbooks. However, when I try and copy the shared workbook a message comes up saying I can't do that. What do I do?
Thank you for the opportunity to help you with your question!
He observes that work expands so as to fill the time available for its completion.
sometimes copying a protected work book may seem difficult what you need to do is simply ensure that you remove any copy protection which may exist on the whole workbook. Protection on single sheet especially done using the using FSAssist menu ensure no problem at all when copying any shared workbook.
Please let me know if you need any clarification. I'm always happy to answer your questions.