Forum Discussion
Solved
Cannot Extend table or database with Form Macro
Hi, I wonder if someone can help me again. I have a worksheet with a hidden data sheet. On one sheet there is a button that has an assigned macro to do the following: - Unhide the data sheet ...
Thanks! The Data Form is rather primitive. It expects the table to begin in row 1. If you delete the current row 1, the code should work. You don't even need to unhide the sheet: you can use
Sub AddDriverForm() Sheets("Driver Data").ShowDataForm End Sub
I didn't get an error in a quick test. Could you attach a small sample workbook demonstrating the problem?
Hi Hans,
Here is the link to the workbook i am working on with the data removed.
The sheets in question are AM Report and the Driver Data sheet.
Thank you so much for the assistance.
https://1drv.ms/x/s!AjkmikH6M6FfgaEStXsEuuu7uy1Qdg?e=2QfC0l
Tom
Thanks! The Data Form is rather primitive. It expects the table to begin in row 1. If you delete the current row 1, the code should work. You don't even need to unhide the sheet: you can use
Sub AddDriverForm() Sheets("Driver Data").ShowDataForm End Sub- Thank you Hans!!! I really appreciate it!!