Ayuda para Libro de Macros Personal

%3CLINGO-SUB%20id%3D%22lingo-sub-2074742%22%20slang%3D%22en-US%22%3EAyuda%20para%20Libro%20de%20Macros%20Personal%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2074742%22%20slang%3D%22en-US%22%3E%3CP%3EBuen%20d%C3%ADa.%20Cada%20vez%20que%20quiero%20guardar%20una%20macro%20en%20el%20Libro%20de%20Macros%20Personal%20me%20aparece%3A%20%22El%20libro%20de%20macros%20personal%20en%20la%20carpeta%20de%20inicio%20debe%20estar%20abierto%20para%20grabar%22.%20%C2%BFC%C3%B3mo%20resuelvo%20esto%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2074742%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2075528%22%20slang%3D%22de-DE%22%3ESubject%3A%20Ayuda%20para%20Libro%20de%20Macros%20Personal%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2075528%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F934788%22%20target%3D%22_blank%22%3E%40AlvaroVT%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIf%20what%20I%20understand%20also%20your%20subject%20is%2C%20then%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E...%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3E%3CSTRONG%3EHow%20can%20you%20edit%20or%20add%20to%20personal%20macro%20recordings%20or%20delete%20the%20code%3F%3C%2FSTRONG%3E%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EOne%20of%20the%20many%20possibilities%3A%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EIf%20you%20are%20in%20the%20development%20environment%20for%20VBA%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3E(you%20can%20get%20there%20using%20the%20key%20combination%20Alt%20%2B%20F11)%2C%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3Eyou%20can%20also%20access%20the%20personl.xls%20modules%20directly%20from%20there%20and%20edit%20their%20content.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EThen%20fading%20in%20and%20out%20is%20not%20necessary.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EBut%20remember%20to%20save%20your%20changes.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3E%3CSTRONG%3EHow%20do%20I%20show%20or%20hide%20the%20personl.xls%20file%3F%3C%2FSTRONG%3E%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EIf%20the%20personl.xls%20is%20not%20currently%20edited%20(it%20does%20not%20necessarily%20have%20to%20be%20displayed%2C%20see%20here)%2C%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3Eit%20should%20be%20hidden.%20Then%20it%20will%20not%20be%20listed%20in%20the%20list%20of%20open%20files.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EThe%20macros%20and%20user-defined%20functions%20are%20also%20available%20in%20the%20hidden%20state.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EIf%20for%20any%20reason%20you%20have%20shown%20the%20file%2C%20please%20hide%20it%20again%20after%20saving%20your%20changes.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3EWhen%20you%20close%20Excel%2C%20you%20will%20be%20asked%20whether%20you%20want%20to%20save%20the%20changes%20to%20the%20personl.xls%2C%20confirm%20this%20because%20this%20query%20relates%20to%20the%20hidden%20state%2C%20you%20have%20already%20saved%20the%20content.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3ETo%20%3CSTRONG%3Eshow%3C%2FSTRONG%3E%20the%20personl.xls%20go%20to%20Menu%26gt%3B%20Window%26gt%3B%20Show%20.....%20Then%20use%20the%20mouse%20to%20select%20the%20personl.xls%20file%20in%20the%20dialog%20window%20that%20opens%20and%20exits%20the%20dialogue%20with%20the%20OK%20button.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%22%3E%3CSPAN%3ETo%20%3CSTRONG%3Ehide%3C%2FSTRONG%3E%20the%20personl.xls%2C%20activate%20the%20personl.xls%20file%20and%20go%20to%20Menu%26gt%3B%20Window%26gt%3B%20Hide%20....%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wish%20you%20continued%20success%20with%20Excel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Buen día. Cada vez que quiero guardar una macro en el Libro de Macros Personal me aparece: "El libro de macros personal en la carpeta de inicio debe estar abierto para grabar". ¿Cómo resuelvo esto?

3 Replies

@AlvaroVT 

If what I understand also your subject is, then...

How can you edit or add to personal macro recordings or delete the code?

One of the many possibilities:

If you are in the development environment for VBA

(you can get there using the key combination Alt + F11),

you can also access the personl.xls modules directly from there and edit their content.

Then fading in and out is not necessary.

But remember to save your changes.

 

How do I show or hide the personl.xls file?

If the personl.xls is not currently being edited (it does not necessarily have to be displayed, see here),

it should be hidden. Then it will not be listed in the list of open files.

The macros and user-defined functions are also available in the hidden state.

If for any reason you have shown the file, please hide it again after saving your changes.

When you close Excel, you will be asked whether you want to save the changes to the personl.xls, confirm this because this query relates to the hidden state, you have already saved the content.

 

To show the personl.xls go to Menu> Window> Show ..... Then use the mouse to select the personl.xls file in the dialog window that opens and exit the dialog with the OK button.

 

To hide the personl.xls, activate the personl.xls file and go to Menu> Window> Hide ....

 

I would be happy to know if I could help.

 

I wish you continued success with Excel

 

Nikolino

I know I don't know anything (Socrates)

It is also helpful to know the operating system and Excel version, as different approaches may be required depending on the version and OS.