Forum Discussion
2019 Excel on Mac no data entry form
I recently switched from PC to Mac. Then I found my Microsoft Access not available on Mac version Office. I tried to use Excel instead by creating a data entry form. Windows Excel 2016 is ok. But Mac...
The Mac edition of Excel has had the data entry Form... capability since at least 1990, when I started using it. Been using it since then. It is now nowheres to be found in Excel Mac 2019.
Does macro work?
Sub OpenDataForm()
Application.CommandBars("Worksheet Menu bar").FindControl(id:=860,recursive:=true).Execute
End Sub
Sub OpenDataForm()
Application.CommandBars("Worksheet Menu bar").FindControl(id:=860,recursive:=true).Execute
End Sub
I tried this on my mac excel but no joy
