I am working on a macro to automate an equipment charge-out form. We are a small environmental firm who uses equipment in environmental clean-up, for which we charge our clients. This is meant to make an invoice for them out of our master equipment list, to prevent wasting paper and sharing rates unnecessarily. It should only copy the rows related to the equipment that project used.
So far:
There is a button to run the macro, which reads sheet1 (named 'DO NOT PRINT') and checks column E. If there is any value in column E, then it copies that entire row to sheet2 (named "PRINT FORM').
It copies values, formatting, and the password protection we have on all unshaded cells.
What we are looking for:
A change that would make sheet2 fully protected, so no cell can be edited after it is copied there, or a 'print only' version (for legal purposes in environmental clean-up jobs).
Is this possible? The current password in the workbook is INTEP
This is the great code submitted to us by AlphaFrog:
Bookmarks