what is meant by "hidden workbook"

[Fred Evans]

Greetings everyone.
I am just learining VBA so will probably be asking a lot of boring questions -
please just humour me ( in other words -Dont laugh)

I recorded a macro and it contains a typing error. When i try to edit it I get a message
"cannot edit a macro in a hidden workbook"
(the macro was recorded into my personal workbook)
first please explain what is meant by "hidden workbook" and then please
give keystrokes to enable me to edit the macro

Many thanks

fred from south africa

 

[steve the fish]

Personal.xlsb is hidden by default and opens when you open an instance of excel. You just don't see it. Instead of pressing EDIT press STEP INTO. This will then bring up the code for your macro.

 

[Fred Evans]

thanks Steve will try it
fred