Thread: SaveCopyAs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Hadrych Greg Hadrych is offline
external usenet poster
 
Posts: 3
Default SaveCopyAs

I am working with the code "SaveCopyAs" and have run in to
a wall. What I want is when I click on a button in my
document; I want excel to ask if the user wants to save
the document and if so, save it as a user defined name and
location. I know I could set the original as read-only
but I do not want to do that.

Private Sub Save_As_Click()

Workbooks("Master Template v2.1.XLS").SaveCopyAs

End Sub

This is the code I have so far but do not know what to
place after "SaveCopyAs"