Copy Workbook without VBA

[MonkeyDance1]

Hi All,

I am trying to see if there is an easy way to create a macro that can be run within a workbook that will create a copy of the workbook without VBA. We have files with VBA internally, but want to show just a superficial copy to the clients so it will simply copy the workbook name, the sheets, and content, but strip the VBA. Any thoughts?

Thanks so much! Forum has always been a great help.

 

[RoryA]

You really just need to save the workbook as an xlsx - that will automatically remove any VBA from it.