Re: Save worksheet as new workbook

Tech-Archive recommends: Fix windows errors by optimizing your registry

First problem solved. I worked at it a little more and all I had to
do was change my order of operations and it worked. I came out with
this.

Private Sub btnFinish_Click()
Cells.Select
Selection.Copy
Workbooks.Add
Active***.Paste
'Active***.Shapes.Range(Array("Button 1", "Button 2", "Button
3")).Select
Application.CutCopyMode = False
'Selection.Delete
Range("P8").Select
end sub


On Apr 7, 10:51 pm, "stewart" <smccallis...@xxxxxxxxx> wrote:
I have a workbook as a template that I do not want to change. Through
a userform button I would like to have VB save "My***" as a new
workbook and have the user be able to choose the name of the new
workbook. Is this possible?


.

Quantcast