AndyTampa
Board Regular
- Joined
- Aug 14, 2011
- Messages
- 199
- Office Version
- 365
- 2016
- Platform
- Windows
I'm working on a macro that I can use at work and hopefully let others use. Right now I'm setting it up so that it checks input data in one column of the main sheet to data on another sheet with proper codes listed. But if it finds an error, I want the user to be able to refresh the codes sheet and rerun the macro.
What I'm looking to do is be able to save the refreshed data to the workbook without saving all the data the user input. I wanted to make this tool Read-only so they can't overwrite the tool itself.
I don't think it's as easy as saying "save worksheet to this file", but I don't know. A workaround I thought of would be to save the input data to a temporary workbook, erase it from the original workbook, save the whole thing, and then copy it back. Is there a better way? I'm a novice, so I may not understand some of the more complicated stuff. Please be gentle.
What I'm looking to do is be able to save the refreshed data to the workbook without saving all the data the user input. I wanted to make this tool Read-only so they can't overwrite the tool itself.
I don't think it's as easy as saying "save worksheet to this file", but I don't know. A workaround I thought of would be to save the input data to a temporary workbook, erase it from the original workbook, save the whole thing, and then copy it back. Is there a better way? I'm a novice, so I may not understand some of the more complicated stuff. Please be gentle.