It's the first tiem I try to write VB code in an Excel spreadsheet and can't get it to work.
I have a book with a number of sheets, in one of them is a combo I'd like to have automatically filled with the names of all the sheets when the file is opened.
I've tried to add some code to the Worksheet_activate event, yet to no avail. What is the right object and event to put my code in?