Sending excel sheet with just values?

[wwgmr]

Hello everyone,

Quick question I hope. I have excel sheet we use for that has grown with my vba work in it. I want to send a simpler version with out code, just values if possible keeping formats of course. Is this possible? IE no modules inclued.

Thanks

 

[SkipVought]

Hi,

Do you have code in the Sheet Object or just in a Module?

If you have no code in the Sheet Object, just copy the sheet to a new workbook.

If you do have code in the sheet object OR you have cells containing more thatn 255 characters, then Add an new workbook and copy the contents of the sheet to the new workbook. This is probably the preferred method...

dim wbNew as workbook,wsOld as worksheet
set wsOld = activesheet
set wbnew = workbooks.add
wsOld.usedrange.copy destination:=wbNew.Sheet1.[A1]

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[wwgmr]

My Mistake, sorry Skip its a full workbook. I should have said that. I do have some small code for button clicks on the sheets but that isn't needed to be included. I just want people to be able to see final results on simple workbook that is not as big as the main one which has all the code.

Thanks again

 

[PHV]

You may take a look here: thread707-805937

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884