I have made some progress on this little project, but could possibly now use some help or advice.
To summarize, I am trying to Show/Hide a specific menu group in a Custom Tab (that is created with Ribbonx) so that it only shows for a specific department workbook. And the workbook file could have many different files name as it based off a department template file.
I can get the that menu group now to hide and unhide using the App_WorkbookActivate Event and checking on a file name. But when I try to have the WorkbookActivate event read a CustomDocumentProperty it gives an Invalid Procedure Error when I launch Excel.
I believe the issue is that I need to somehow first check if that CustomDocuementProperty exist before attempting to read its value? But I’m not certain yet on how to do that.
This is the code used in the App_WorkbookActive
And I know the CustomDocProp exists as I can debug.print it in the departments template file
Bookmarks