Is there any way to check if a certain custom ribbon is loaded or not?
At present I'm using an error trap. If error No is 32610, the ribbon is already loaded.
But I really hate to cause an error and then use error handler to get ride of.
If possible I prefer not to trigger the error at all.
I know I can use this :
But it works only after the custom ribbon is loaded. If I use it before custom ribbon is loaded, I receive a property doesn't exist error.
Thank you.
At present I'm using an error trap. If error No is 32610, the ribbon is already loaded.
But I really hate to cause an error and then use error handler to get ride of.
If possible I prefer not to trigger the error at all.
Code:
On Error GoTo ErrorTrap
................
ErrorTrap:
Select Case Err
Case 32609, 32610
' Ribbon already loaded
....Do This
case else
End SELECT
I know I can use this :
Code:
MsgBox CurrentDb.Properties("MyCustomRibbon")
But it works only after the custom ribbon is loaded. If I use it before custom ribbon is loaded, I receive a property doesn't exist error.
Thank you.
Last edited: