Hello,
How do I add a command button to a worksheet (not the tool bar) and have it respond to click events?
Also, I want my macro to check a variable (FileName) against all sheet names in workbook and return a value a could right an If statement with to exit if there is a duplicate. How would I go about this?
Finally, I would also like to clear all sheets except "Sheets1". Is there an easy way to do this?
Thanks a bunch for any insight,
Luke Campbell
How do I add a command button to a worksheet (not the tool bar) and have it respond to click events?
Also, I want my macro to check a variable (FileName) against all sheet names in workbook and return a value a could right an If statement with to exit if there is a duplicate. How would I go about this?
Finally, I would also like to clear all sheets except "Sheets1". Is there an easy way to do this?
Thanks a bunch for any insight,
Luke Campbell