"Earl Kiosterud" wrote in message
...
StarGateFan,

I think you can put your macros in personal.xls (or any open workbook),
then
run them with keyboard shortcuts or whatever.

Sub PutMyFormula1()
ActiveCell.Formula = "=SUM(A1:A10)"
End Sub

<lol Yes, sorry; I didn't explain well enough I see. I've been saving
macros to my PERSONAL.XLS for some time now thanks to learning how in this
ng! <g

I'm not sure the macro coding will work for what I want to do. What I was
hoping for was the macro coding to send text to a new sheet in Excel but
that I can access at any time so it would probably also have to be written
to the PERSONAL.XLS. (It's because I can't remember the jargon for that so
I had to explain it in a roundabout way.) I'll try again. i.e., how could
I get a macro in the PERSONAL.XLS to send this text below between quotes to
a new Excel sheet:

"The horse was in the field eating grass."

The example is silly, I know, but it's just an example <g. It's because I
tried but just ended up with a messed up PERSONAL.XLS. Good thing I knew
enough to fix it, though.

Thanks!

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"StargateFan" wrote in message
...
Is there a way to have a macro type out text in a new spreadsheet?

I've done this in Word but not sure how to do it in Excel. The Word
macro creates a table and populates the cells with data that I often
need. The macro gets saved with the normal.dot so it saves me a ton
of grief since I don't have to cart around the info in a separate
template yet I have the data handy whenever I need it.

I was hoping for something similar in Excel to access formulas I use a
lot so I don't have to cart templates around for that, too. I'd then
be able to create a toolbar for excel tips, say, and have those
most-used formulas accessible by a couple of clicks on that toolbar.

Thanks.