How to load custom Ribbon based on user

[Agoodman]

Hi Everyone,

I've been a long time user of MrExcel and all sorts of ideas and suggestions and fixes... for that I say a hearty THANK YOU!

Today however I can't seem to find the answers I seek. I have become well versed in Ron de Bruin's examples, and I have my custom ribbon built, and functions perfectly.

Here's my dilemma, I cannot find an example or instruction on how to call a custom ui based on the user opening the file.

Example:

when I open the file, I would like the entire ribbon to open as normal and anyone else, gets the "Dictator" treatment of having no ribbon and no backstage, using a simple if statement...

if Application.Username = "Doe, John" Then goto loadnormal ELSE goto lockdown

Anyone have any ideas how to accomplish this?


Thanks in advance

 

[Agoodman]

Bumping from page 19

 

[Agoodman]

Bumping from page 54