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]

Actually i have unhidden it but another error comes up when I run it.

runtime error 50132 - Method 'Name' of object'_VbComponent' failed.

 

[footoo]

It works for me.

Have look at these two links:

Registry Clean Up - Runtime Errors / 50132

Runtime Error 50132 - Solution to Runtime Error 50132 - How to Repair Runtime Error

 

[Dazzawm]

Thanks, but because its a work PC I don't want to download programs and possibly cause more problems! Can I put my PMW add-in onto my PC, make the changes, then put back onto this one?

 

[footoo]

Thanks, but because its a work PC I don't want to download programs and possibly cause more problems! Can I put my PMW add-in onto my PC, make the changes, then put back onto this one?

That should work but instead, I suggest you manually change the module names - it would be quicker.
We have both spent too much time trying to do it programmatically.
With 60 modules it should only take about 10 minutes to do it manually.

In case you do not know how to do:
[FONT=&quot]Open the module in the Visual Basic Editor.[/FONT]
[FONT=&quot]If you don't see the Properties pane, select View | Properties or press F4.[/FONT]
[FONT=&quot]The first property in the Properties pane is the (Name) property. You can edit it there and press enter.[/FONT]