Hi all,

My being developed worksheet layout got ruined since I have some new code in
it , so I want to copy old worksheet without code module behind.

Clara
--
thank you so much for your help

hi,
here is a save range macro i wrote for myself some years back.
but if it is just a one time thing, you can just as easily copy the sheet
and paste it in a new workbook.
Sub mac1SaveRange()

'Macro written by FSt1 4/27/03

Dim cnt As Long
Dim cell As Range
On Error GoTo err1

MsgBox "You have selected range" & Selection.Address
If Selection.Cells.Count = 1 Then
If MsgBox("You have selected only one cell. Continue?????", vbYesNo,
"Warning") = vbNo Then

Exit Sub
End If
End If
cnt = 0
For Each cell In Selection
If Not IsEmpty(cell) Then
cnt = cnt + 1
End If
Next
If cnt = 0 Then
If MsgBox("There is no data in the selected range. Continue?!?!?!?!?",
vbYesNo, "Warning") = vbNo Then
Exit Sub
End If
End If
'ActiveSheet.UsedRange.Select
Selection.Copy
Workbooks.Add
Range("A1").PasteSpecial xlPasteAll
Application.Dialogs(xlDialogSaveAs).Show
err1:
MsgBox ("Need a range to save.")
Exit Sub
End Sub
regards
FSt1

"clara" wrote:

Hi all,

My being developed worksheet layout got ruined since I have some new code in
it , so I want to copy old worksheet without code module behind.

Clara
--
thank you so much for your help