saving without macros

[homer15]

does anyone know if there's a way to save an excel workbook without carrying over the macros? i have a workbook that gets all of it's information from macros, but then it gets shared among several people. i would like them to view it without the macro code attached to the sheets.

[doctorgonzo]

If you want to keep people from seeing the macros, you can password-protect them.

When you go to edit your macros in the VA editor, go to Tools...VBA Project Properties, and then go to the Protection tab. Select "Lock project for viewing" and enter a password. Then, only those who have the password can look at the macros. They can still be used, however.

[pillainp]

If you only want people to see the data that is contained in the workbook, you could always save it and transmit it as a "Comma Separated Values" file (.csv in Save As>Files of Type dialog). This strips the file of all macros and saves the file as a simple text file with the values separated by commas. That way, people can open it in Excel without the risk of their running the macros in the original workbbook. The file will open automatically in Excel by default and will be correctly formatted into rows and columns.

Just one of the options. Hope it is useful.

NPP

[homer15]

thanks guys.
doc: when someone here opens up the workbook, they get the macros contain viruses, blah blah blah message, where they can choose to enable or disable macros. if i were to just hide the macros, they'd still get that message. i just want that message to go away.

pillainp: i'd still like them to be able to view this stuff in a spreadsheet, so they can sort by whatever field they want. thanks again, guys. any other ideas?

[sdkfz]

Here is my 2 cents - copy and paste the spreadsheet but do it specially........

You will need to do this worksheet by worksheet so I hope this is not too big or too frequent. What you do is copy and then paste special (Right click (assuming right handed moue)), select first values and then paste special again for format, now you have a snapshot of the worksheet but no formulas etc.

Column widths do not seem to work too well so you maight be best off saving a blank with the columns the way you want as a template should this be a recurring thing.

[pillainp]

Homer15,
When you open a Comma Delimited file (*.csv) in Excel, the values in the file will open as a spreadsheet on which all the normal operations possible in Excel can be performed. You will just not have transmitted any of the macros in the original workbook. Only hitch is that each spreadsheet in the workbook, if there are multiple spreadsheets, must be saved as a separate CSV file. Try it out and see.

NPP