I have the following VBA code, which should show a dataform from another hidden sheet.
Sub CoverageBssEntry() Application.ScreenUpdating = False Sheets("myhiddensheet").Select Range("myTable[#All]").Select ActiveSheet.ShowDataForm End Sub
When I run this, the data form does not containt the labels and inputboxes of this table.
Any help is really appreciated, because it is driving me nuts! My only other option is to spend time to build custom made user forms, while this would do perfectly.
You cannot select a hidden sheet. And anyway the
.Select statements are not necessary