Log In
Register
Home
Trusted Members
October 17, 2018
Offline
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.
See Answer
Trusted Members
Moderators
November 1, 2018
Offline
Custom ribbons don't work for hidden normal workbooks (i.e. that don't have the IsAddin property set to True).
Trusted Members
October 17, 2018
Offline
Hmm, makes me think, I'll do some testing and update, thanks for thinking with me
Trusted Members
October 17, 2018
Offline
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
Answers Post
1 Guest(s)
