I would just like to thank everyone that responded to my questions ove
the past few days, and putting up with my ignorance!
The program that I was working on is finally finished, except for on
thing-
When i activate the macro below, it will save all the worksheets, an
then display the save-as window as it is suppose to. If i cancel it a
this point and don't name it, it will close the program and save i
with its base name in a value format, which means i loose all th
formulas in the program.
Is there a way to safe guide the base program and this from happening?
Secondly, I would like to learn more about Visual Basics, could anyon
advise me on what would be a good way to learn the basics
legepe


Sub special()
Dim wsheet As Worksheet
With Application
.ScreenUpdating = False
.DisplayAlerts = False
.Dialogs(xlDialogSaveAs).Show
For Each wsheet In Worksheets
wsheet.Unprotect
With wsheet.UsedRange
.Copy
.PasteSpecial xlPasteValues
End With
wsheet.Protect
Next wsheet
.ScreenUpdating = True
.DisplayAlerts = True
End With
ActiveWorkbook.Close True
End Su

--
legep
-----------------------------------------------------------------------
legepe's Profile: http://www.excelforum.com/member.php...fo&userid=1548
View this thread: http://www.excelforum.com/showthread.php?threadid=27255