Working on a spreadsheet I created but I struggle with the macros. Can someone please assist? I have a spreadsheet with formulas and want a macro that will select the active workbook only, make it Values Only for the active workbook, and then save the Values Only version in a different location.
I need to change it so that:
1) In only applies to the active workbook
2) No changes are made to the active workbook, but:
3) The values-only workbook is saved in another location automatically, the location will be hardcoded in the script.
Thanks in advance!!
Bookmarks