Why unhide personal.xls to modify a macro

[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

 

[Tom Ogilvy]

There would be no reason to unhide the workbook.

 

[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.

 

[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)????

 

[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..."

You sure?

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

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

 

[Dave Peterson]

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

Sorry about my confusion.

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..."

 

[Tom Ogilvy]

but if you select one, and click the Edit

button

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

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..."

 

[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.

 

[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!)

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

Sorry about my confusion.

 

[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

 

[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.

 

[Dave Peterson]

And over 65% of it is accurate!

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.

 

[Debra Dalgleish]

Just like the real world!

And over 65% of it is accurate!