Hello,
I have Excel for Mac 2019 und want to design UserForms in the VB editor.
I can create new UserForms end edit them in the designer window but once the designer window was closed it cannot be reopened.
With right click on the UserForm entry in the Projekt explorer there is no entry to open the object. Double clicking the entry opens the code window. Clicking either of the two icons left besides the folder icon in project explorer also only opens the code window.
In Excel for Mac 2011 the design window can be reopened after closing. Is there a way to do it in Excel for Mac 2019?
I even tried to open the DesignerWindow programmatically:
This works in Excel 2011 but not 2019.
Am I missing something?
Does anyone have an idea hot reopen the designer window in 2019 version of Excel on Mac?
Greetings
D.Mon
I have Excel for Mac 2019 und want to design UserForms in the VB editor.
I can create new UserForms end edit them in the designer window but once the designer window was closed it cannot be reopened.
With right click on the UserForm entry in the Projekt explorer there is no entry to open the object. Double clicking the entry opens the code window. Clicking either of the two icons left besides the folder icon in project explorer also only opens the code window.
In Excel for Mac 2011 the design window can be reopened after closing. Is there a way to do it in Excel for Mac 2019?
I even tried to open the DesignerWindow programmatically:
Code:
ThisWorkbook.VBProject.VBComponents("Userform1").DesignerWindow.Visible = True
Am I missing something?
Does anyone have an idea hot reopen the designer window in 2019 version of Excel on Mac?
Greetings
D.Mon