small problem with save as

  • Thread starter Thread starter Vato Loco
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

save when populated 6
save as filename 3
saving without prompt within code 2
Auto-logging worksheets 1
Macro to automatically save document with cell reference as filena 1
Make code apply to more than 1 column 6
macro save 8
Save workbook with a name mentioned in a cell 1

Back
Top