small problem with save as

V

Vato Loco

I'm using this to save my workbook as needed but it keeps asking me t
save every time I touch the sheet.....


Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
ActiveWorkbook.SaveAs FileName:=ActiveSheet.Range("g18")

End Sub

I need to edit this worksheet before I save it. PLease Help!!!

Thanks, Vat
 
D

Dave Peterson

Open that workbook with macros disabled.

Tools|macro|security
(set it to the highest possible)

Open your workbook
Toss that macro out--It's pretty drastic
Save your workbook

reset the security level the way you really like it

And test it out.
 
Top