Forum

Custom UI Ribbon an...
 
Notifications
Clear all

Custom UI Ribbon and QAT in Personal macro book

4 Posts
2 Users
0 Reactions
172 Views
(@keebellah)
Posts: 373
Reputable Member
Topic starter
 

Hi,

I've been playing around with the idea for quite some time but without succes.

I'm using Excel 2021

I have tried adding the CustomUI xls part to the Personal macrobook 

My alternative for now is an xlam file in the XLSTART folder where the Ribbon is activated and macro's triggered correctly but I was wondering if the same could be achieved with the Personal macrobook.

I would also like to have the QAT settings as well which is another issue that does not seem to work in the PM

Any hints, tips ideas are welcome.

 
Posted : 12/01/2024 3:20 am
(@debaser)
Posts: 836
Member Moderator
 

Custom ribbons don't work for hidden normal workbooks (i.e. that don't have the IsAddin property set to True).

 
Posted : 12/01/2024 7:32 am
(@keebellah)
Posts: 373
Reputable Member
Topic starter
 

Hmm, makes me think, I'll do some testing and update, thanks for thinking with me

 
Posted : 13/01/2024 4:07 am
(@keebellah)
Posts: 373
Reputable Member
Topic starter
 

Late to answer but what  I wanted did not work as you, Velouria, pointed out.

My tests resulted in a xlam that is triggred from within the Personal.xlsb so I got what I wanted.

Post closed

 
Posted : 04/04/2024 4:47 pm
Share: