Just use or just save and all works well. Note that under the workbook_open section, I'm calling individually the Delete procedure, which deletes the buttons that were there previously and then Buttons, which draws and names the new buttons. I've been frustrated in trying to figure out what's going on? Has anyone seen this behavior before? Any ideas as to how to fix this problem would be greatly appreciated. That named option button will not trigger. When I run the code from the VBE, it executesįine, i.e., it draws the option buttons and names them accordingly however, when I save and open the file, some of the names do not match what I've named them, i.e., the Name under the Property field doesn't match what I've named it, so any code written for I'm assigning them unique names and grouping them under the Group1 group name. I am running the following code that gets triggered during the Workbook_Open event the code draws 5 Option Buttons on a worksheet.
0 Comments
Leave a Reply. |