Does anyone know why i cant see my personal macros when customising the quick access bar?

[tonywatsonhelp]

Hi Everyone,
I have a lot of macro in my personal.xlsb

I can see then and use them in my documents for example clicking on the macros button shows them all
however i like to add some to my Quick access bar but when i open it up and go to macros its only showing me my macros for the workbook i'm in?
any ideas why this might be?
I''ve done the close everything down and start again thing, lol

thanks

Tony

 

[Joe4]

Did you change the setting when you go to View Macros to show the Macros in "All Open Workbooks"?

 

[tonywatsonhelp]

Yes, my macros show there, they just dont show up in the customise quick access area when i choose macros, i just my whatever macros are in the document? its very strange?

 

[tonywatsonhelp]

acctually i just checked and they are not showing up in macros area either? yet i can see them when i open the VBA window???

 

[Joe4]

acctually i just checked and they are not showing up in macros area either? yet i can see them when i open the VBA window???

What do these procedures look like?
Any procedure that begins with the word "Private" or takes in parameters will not show up in the list.

 

[RoryA]

Does your personal.xlsb appear in the list of disabled items in the manage add-ins dialog? Or did you change the IsAddin property of the personal macro workbook to True?

 

[tonywatsonhelp]

Hi Everyone,
I decided there was only one thing for it,
I exported all my modules
Deleted the personal doc
created a new one
Imported all the moduals
everything is back to normal
Thanks for trying to help,

Tony