Search results for query: *

Thank you all for the answers. Looks like prompting with an input box, using code to check that the user input conforms to the conventions my firm requires, error trapping to ensure the new name conforms to excel's conventions, and re-prompting if necessary is the way to go. I'll get working...

Hi, I've created a macro to copy a worksheet to the first position in a workbook and clear the user contents cells. Simple enough. Before I exit, I'd like to highlight the new worksheet's name tab, so the user is prepped to give the worksheet a descriptive name. The macro record feature...