record macro "That name is not valid."


H

highlifesipper

I'm trying to learn how to use macros and start out by trying to record one.

I went:
Tools
Macro
Record New Macro....

For "Macro name:" I left "Macro1"

click "OK" and get an error message...."That name is not valid."

I've tried everything....starting with a letter, no spaces, opening a new
workbook...keep getting the same error message
 
Ad

Advertisements

F

FloMM2

highlifesipper,
The only time I get your error,
is when I have a macro name of "Macro 1"
which is not the same as "Macro1"
Try deleting everything in the bolck &
type"Macro1"
hth
 

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

Top