Hello,
I have a workbook that tracks vehicles in our company that are out of service for any given reason. The first sheet in the book is where users enter data as vehicles go out of service, and then again as they are fixed and go back into service.
I have formulas that tabulate information based on this information, unfortunately users are deleting entire rows, copying and pasting, and causing me to constantly have to reformat.
I am looking for the code to complete the following.
1/ disable cut, copy, paste when the workbook is opened.
2/ when a user changes the "Status" (in a drop down box) to "Completed" I want to have the entire row of information moved (have the formula copy and paste it to another sheet) to the history tab (in the first blank row).
Can anyone help with this?
Would be greatly appreciated.
Thanks,
Todd
Bookmarks