Hi

Can someone please advise on how can I copy active workseet to a new
workbook without copying the macros along with it (the workbook I am copying
the workseet from ahas nacros in it). i.e copy just the sheet & its value but
keeping intact the formating.
All this using VBA.

Thanks a lot in advance for your help
J