Hello,
I am working on a "master" workbook with multiple sheets that needs to be shared by numerous people. Specific sheets and only specific sheets need to be shared with an end user who does not need any formulas or links. (they need only the output).
I have been trying to record a macro that will do the following (with little success)
1.--Copy the active sheet
2.--remove all links, formulas, data validations and conditional formats
3.--Cut the new, clean sheet into another workbook (not a copy) for manual renaming and saving.
These are the steps and order I am trying but can't quite seem to get it. Any feedback helps.
Bookmarks