Personal Macro Workbook

[Dazzawm]

I'm curious about the PMW. Why are the codes within all listed twice like:-

PERSONAL.XLSB!HighlightData.HighlightData

Why cant it be simple and more understandable like when you put a module within a file like:-

HighlightData

Or can it be?

 

[Dazzawm]

Try it on a test workbook before trying it on your Personal workbook.

Sorry how would I do that?

 

[footoo]

Open a new workbook, add a few modules, follow the post #8 instructions and run the macro.
Check what it does to the names of the modules.

 

[Dazzawm]

I did as you said to the letter but I get a runtime error - Programmatic access to Visual Basic Project is not trusted.

 

[footoo]

Did you do this step ? :-
First, go to the VBE, click Tools/References... and put a check mark against "Microsoft Visual Basic for Applications Extensibility 5.3"

 

[footoo]

Go to File -> Options -> Trust Center -> Trust Center Setttings -> Macro Settings -> Trust Access to the VBA Project object model.

 

[Dazzawm]

Ok that worked and only one description was in view when I went to view macros. How do I point it to the PMW now?

 

[footoo]

Open the Personal workbook, make sure it is the active workbook and run the macro.

 

[Dazzawm]

The PMW always opens when I open a file, how do I make it the 'active' workbook?

 

[footoo]

Unhide it.

 

[Dazzawm]

As far as I can see it is unhidden. When I right click on PERSONAL.XLSB it says 'Hide'?