Excel VBA - How to control live work in Workbook after executing a macro
Posted on 2014-08-13
I've created a macro that opens a workbook. Using the macro I protect that workbook, keeping some cells available for editing. The User should be able to work in the workbook, and when the work is finished then the work can be saved.
Problem is: when the workbook becomes available to the User, the User can press File > Save As, and save the workbook somewhere, and also I have no control on when the user finishes the work. How can I give a button indicating Save (I know how to give a button), so that that button triggers saving of the open file.