Just wanted to know is it possible to run VBA save new copy of file without macro button and VBA Code?
My master copy is .xlsm format. After clicking the macro button on my master copy, it will become .xlsx file.
Can we or does VBA able to run a code without macro button and VBA Code on the new saved copy? Except the formula on all the cells remain unchanged.
Hope to get advise and guide from you guy
My current code as below, result from google and modify a little.
Please Login or Register to view this content.