Table Forms is Great!

I just tested AEF MacResized 3.48 in Excel beta version 16.81 in a beta version of Mac OS Sonoma version 14.3 and found this to be exceptionally good.

There was an odd bit of misbehavior. When I chose to Launch the Auto Form or Launch Browse & Find, the dialogs didn't display until I switched to a different app. For some reason the screen doesn't redraw after these dialogs are supposed to display. I'm not sure what code can be added to force Excel to refresh the screen to display these dialogs instantly. This could be a bug in Sonoma, but I don't have another Mac to test with.

There is no "Trust Center" in Office for Mac. To enable the setting for Trust Access to the VBA Project Model use the Menu Bar and choose Excel > Preferences > Security, then click the check box for Trust Access to the VBA Project Model.

To get to the VB Editor press Option+F11 or fn+Option+F11 (if you have a small keyboard). To set a reference in the VB Editor, use the Menu Bar and choose Tools > References. In the References dialog click the checkbox for Microsoft Visual Basic for Applications Extensibility 5.3, then click OK to close the References dialog. Press Command-Q to leave the VB Editor.

I really like that you can change the fonts, font sizes and colors in the form.

​