Hello all,
Greetings!

I need suggestions/help in my excel project.
There's a part in my project where clicking on a CommandButton triggers a 'SaveAs' option for the end user and it generates a new file.
And the user is forced to save the new file in .xlsx format. But my concern is, in new file the user will still be able to right click on the worksheet and view the VBA code thru 'View Code' option. I don't want end user to view the VBA code in that new sheet.

Please suggest.
Also let me know if I was not clear explaining my problem.