Aug 14 2020 10:32 AM
How can I automate macro execution so that a macro is executed when a workbook is opened without the user doing anything else. I need computer illiterate users to be able to simply click on a link in Word document and be presented with a data entry form.
Aug 14 2020 11:00 AM
Aug 14 2020 03:15 PM
Many, many thanks. Your suggested solution looks like it's exactly what I need. I just tested it with a simple MsgBox "Hello!", invoking another VBA module to display "Hello yourself", and it worked exactly as I had hoped. Now to put some meat in the process.