saving from a template with vba

[SKaufman]

We have a template with vba code that automatically saves a
spreadsheet to a specified location. How do you save the spreadsheet
without all of the code. When the user opens the spreadsheet we do not
want them to see the forms, etc., just the data. Thanks.

 

[Dave Peterson]

Chip Pearson has some sample code to remove all the VBA from a workbook at:
http://www.cpearson.com/excel/vbe.htm

But I like to just create a new workbook, copy the cells from the existing
worksheet and paste them into the a new worksheet in that new workbook.

(Maybe a paste special|formulas, and then a paste|special formats).

If your worksheet didn't have any code behind it, maybe you could just copy that
worksheet to a new workbook.

Record a macro when you do this and your macro will be started.