Tom, I did the following with your code but it seems to just lock my
computer up. Made this a button macro. Should it be used someother
way?

__________________________________________________ __________


Sub Button5_Click()

With Workbooks("Maker.xls")
For Each sh In .Worksheets
sh.Cells.Formula = sh.Cells.Value
Next
..SaveAs ThisWorkbook.Path & "\Maker II.xls"
End With

End Sub


--
sungen99
------------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=564808