Why unhide personal.xls to modify a macro

B

Brian Tozer

Many tutorials state that to create or modify a macro in the personal.xls
workbook it needs to be unhidden.
I seem to be able to view and modify such a macro when it is hidden.
Why the apparant discrepancy?
I am using Excel 2002.
I an confused.

Brian Tozer
 
D

Debra Dalgleish

When Personal.xls is hidden, you can't access its macros through
Tools>Macro>Macros.

However, you can press Alt+F11, and in the Visual Basic Editor, create
or modify a macro in Personal.xls, whether or not it's hidden.
 
D

Dave Peterson

You sure?

I could see the macros in a small test (xl2002).

Maybe you meant if you saved it as an addin (personal.xla)????
 
D

Debra Dalgleish

You can see the macros, but if you select one, and click the Edit
button, a message should appear that says, "Cannot edit a macro on a
hidden workbook..."

Dave said:
You sure?

I could see the macros in a small test (xl2002).

Maybe you meant if you saved it as an addin (personal.xla)????
Click to expand...
 
D

Dave Peterson

Ahhh. I see your point. Access <> Run.

Sorry about my confusion.



Debra said:
You can see the macros, but if you select one, and click the Edit
button, a message should appear that says, "Cannot edit a macro on a
hidden workbook..."
Click to expand...
 
T

Tom Ogilvy

but if you select one, and click the Edit
button
Click to expand...

Who would use that method to edit a macro? <g>

If your going to edit a macro, go to the VBE - as they say

"if your going to get a dog, get a dog!"

--
Regards,
Tom Ogilvy


Debra Dalgleish said:
You can see the macros, but if you select one, and click the Edit
button, a message should appear that says, "Cannot edit a macro on a
hidden workbook..."
Click to expand...
 
D

Debra Dalgleish

Nobody I know! <g>

However, the original question referred to tutorials, and many that I've
seen start with recording macros, and accessing the code through this
dialog box. They don't explain other (better) methods.
 
D

Debra Dalgleish

Bad explanation on my part -- I had written a much longer version, but
thought it was too long and boring, so I trimmed it (too much, apparently!)

Dave said:
Ahhh. I see your point. Access <> Run.

Sorry about my confusion.
Click to expand...
 
B

Brian Tozer

Thanks very much Debra.
Your post and the subsequent discussion has totaly illuminated the confusion
and the apparant contradictions that I encountered.
It isn't easy being a newbie. :)))
However you newsgroup posters do make self-learning possible.
Brian
 
D

Debra Dalgleish

You're welcome. Sometimes, what's in the textbooks and tutorials isn't
the most efficient way to perform tasks. If you keep reading and asking
questions here, you'll get lots of 'real-world' advice.
 
D

Dave Peterson

And over 65% of it is accurate!


Debra said:
You're welcome. Sometimes, what's in the textbooks and tutorials isn't
the most efficient way to perform tasks. If you keep reading and asking
questions here, you'll get lots of 'real-world' advice.
Click to expand...
 
Top