Save Excel Workbook without Code

[hrsnblm]

Hi. I have a workbook that does some data manipulation and graphing and then does a SAVEAS at the end.The problem I have is that I do not want to save the VBA code in this new workbook/file. It only supposed to be the data and graphs. How can I do this? How can I either eliminate the code before I SAVEAS, or is there an option in the SAVEAS command that allows me to not save the macros/code?

Thanks ahead of time for any and all assistance.

 

[SkipVought]

Hi,

Create a New Workbook
You must Copy each Sheet to the new workbook.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[hrsnblm]

This will leave out the VBA code/macros from the new workbook?

 

[SkipVought]

Are your macros in a MODULE or in one of the Sheet Object Code Windows?

If in a MODULE, then yes. Otherwise no.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[hrsnblm]

My code is restricted to a form that occurs at start-up, and to my ThisWorkbook. There is none directly associated with the sheet(s).

 

[HughLerwill]

This is difficult to implement unless the User has "Trust access to Visual Basic Project" ticked in his Excel Macro Security Settings, so something like;

Sub MyMacro

'Lots of Code

'Remove me
'error occurs if "Trust access to Visual Basic Project" is unticked
On Error GoTo SkipIt
With ActiveWorkbook.VBProject.VBComponents
'discard the macro code
.Remove .Item("ModuleName")
End With

SkipIt:

End Sub

is the best I have so far with recommendations (re small file sizes) and warnings (re security issues) to users.

 

[hrsnblm]

Thanks. I will give it a try and feedback what happens.

 

[HughLerwill]

Skip, sorry I had'nt seen your post before I sent mine, copying out to a new WorkBook is an obvious example. I had been concentrating on the current WorkBook.

 

[SkipVought]

No problem. There is more than one way to skin a cat! ;-0

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}