Hi Paul..thank you!!! that worked! i was avoiding that strategy in the beginning because the unwanted macros remain in the saved workbook....but at the same time, if there is no code that can transfer macros of one worksheet, then this does end up being a wonderful option.
Thank you so much!!!