Macro to create copy of a .xls file (Beginner)

Hi Guys,

I need to create a macro/code which will allow users to click a button in a worksheet this should then create a copy of the file as another file with a similar name but this copy would have all the coding removed so other users are not able to click this button and update any sheets.

Any help much appreciated.

Welcome to the Forum. Please read the Forum Rules & then use the Edit button to amend this post's title.