My spreadsheet has 3 buttons which run macros and then columns of data under the buttons. I need to save the spreadsheet information to a new spreadsheet but not the macros. How would I do this?
I've tried to use the saveas method but it saves the macros as well.
I've tried copying the range to a new sheet and then saving, but it still keeps the macros.
Any help will be appreciated.
Lhuffst
I've tried to use the saveas method but it saves the macros as well.
I've tried copying the range to a new sheet and then saving, but it still keeps the macros.
Any help will be appreciated.
Lhuffst