MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Sending or copying EXCEL spreadhseets


Posted by Ron on December 06, 2001 12:55 AM

I want to send the results of about 70 TABS plus a recap sheet but i do not want to send the formulas...

How can I copy or save to floppy and forward without allowing the ohter person to see my formulas?

Thank you!!!

PS: I know you can copy and do a Paste Special but that is very time consuming..


Posted by Colo on December 06, 2001 1:21 AM

Hi Ron.
You said
:I know you can copy and do a Paste Special but that is very time consuming..
I think so too, but all I know is to use PasteSpecial method or value property.
And This work can be automated by VBA.

Please try after copying the data file.

Sub OnlyValue()
Dim sh As Worksheet, st As Single
st = Timer
Application.ScreenUpdating = False
For Each sh In Worksheets
With sh.UsedRange
.Value = Value
End With
Next
Application.ScreenUpdating = True
MsgBox "...Done. Sorry for Waiting...It takes" & Timer - st & " sec"
End Sub