Why are you angry, Bob? The way I've created Macros is by clicking on
record Macro, doing a few things, then clicking on stop recording. So when
I say I've written macros, I guess it is better to say I have "recorded"
them. I don't know how to write from scratch. I don't know where to start.
I have spent hours searching for online help, but the results I find are not
basic enough. I need Visual Basic for dummies.

"Bob Phillips" wrote:

How can you say you have written tons of macros, but say that this is
different.

It should be End Sub, not End Sun.

--
__________________________________
HTH

Bob

"Gator Girl" wrote in message
...
Hi Sheeloo - I don't know the first thing about this. I've written tons
of
macros, but this is different. What is a Sub Copymacro( )? What is an
End
Sun. Where do I start doing this? Pretend I am really stupid
(generally
I'm not but about this, if the shoe fits....)

"Sheeloo" wrote:

Put a Sub Copymacro() before the code
and End Sun at the end.
Make updates as marked in the code
THEN
1. Open the Visual Basic Editor by going to tools-Macro's-Visual Basic
Editor or use Alt-F11
2. On the toolbar of the Visual Basic Editor, go to insert - module
after
selecting the workbook on the left in which you want to use this code
3. In the module pane paste the code above.
4. Close the Visual Basic Editor By clicking the X in the upper right
corner or go to File-Close

"Gator Girl" wrote:

DAVE PETERSON SAYS TO USE THIS: BUT HOW DO I SET IT UP? ALT-F11 and
THEN
WHAT?
dim wks as worksheet
set wks = worksheets("somesheetnamehere")
wks.copy 'copies to a new workbook--single sheet
'save the newly created single sheet workbook.
with activeworkbook
.saveas filename:="C:\..."
.close savechanges:=false
end with