![]() Hi Julie First of all, no, there's no (simple, reliable) way for you to keep the focus on the Add-in tab. If you have any feedback on our support, please contact remember to mark the replies as answers if they help and unmark them if they provide no help. you could refer to this earlier thread: Hope this could help. If you need to programmatically move the foucs on to the Add-In Tab, it will be a long story to tell. ![]() ![]() ' (xlSrcRange, Range("$C$9"),, xlNo).Name = "Table1" Range("Table1,]").Select End Sub If remove the last line of above code, we'll be able to avoid the issue. This VBA code could demonstrate how this issue comes: Sub Macro1() ' ' Macro1 Macro ' Hello Julie, Welcome to MSDN Forums! If code include some steps to insert a table into the worksheet, the behavior may be some different with Excel 2003, the Design tab will be activated if your code selectd any cells inside the Table after insert.
0 Comments
Leave a Reply. |