You can certainly strip VB Code from spreadsheets ... but one has to wonder
if the code is stripped would this not disable\destroy any user commissioned
fuctionality?

Can't have it both ways: either you have an automated spreadsheet with its
embedded VB code *OR* meaningless, non-functional controls and the basic data
itself.

Quoted material below is taken directly from Chip Pearson's web site:

***** Begin Quoted Material *****

Deleting All VBA Code In A Project

The procedure below will delete all the VBA code in a project. You should
use this procedure with care, as it will permanently delete the code.
Standard modules, user forms, and class modules will be removed, and code
within the ThisWorkbook module and the sheet modules will be deleted. You
may want to export the VBA code, using the procedure above, before deleting
the VBA code.

Sub DeleteAllVBA()

Dim VBComp As VBIDE.VBComponent
Dim VBComps As VBIDE.VBComponents

Set VBComps = ActiveWorkbook.VBProject.VBComponents

For Each VBComp In VBComps
Select Case VBComp.Type
Case vbext_ct_StdModule, vbext_ct_MSForm, _
vbext_ct_ClassModule
VBComps.Remove VBComp
Case Else
With VBComp.CodeModule
.DeleteLines 1, .CountOfLines
End With
End Select
Next VBComp

End Sub

***** End of Quoted Material *****

--
Penraig
Esse quam videri


"DynamiteSkippy" wrote:

Is there a way to save a file without a particular module being saved?

I have a client who is extremely sensitive and doesn't like the macro
security message which pops up anytime there is a file which has visual basic
code in it.
I simply want to eliminate that message from popping up and force it to
"Disable Macros" Any thoughts???