Worksheet.Activate does not fire when workbook is opened

[EdNerd]

(Using XL 2016 on Win10) I have code for a certain worksheet in the Worksheet.Activate code to add an item to the right-click menu when the sheet is activated. Other code removes the item when a different sheet is acivated.

But if this sheet is the active sheet when the workbook is opened, the Worksheet.Activate code doesn't run?? How do I get around this??

 

[GWteB]

Switch to another sheet and switch back when the workbook is opened using the Workbook_Open event.

 

[EdNerd]

Wow! So simple ... No wonder I didn't see it! Thank you.

 

[GWteB]

Glad to help and thanks for the feedback