user input name tabs

  1. H

    macro to change worksheet names

    I'm running windows xp sp3 and using excel 2007. There are 7 worksheets in this document, and each worksheet has a date for a name. Each week the worksheets are manually updated with the new dates. I would like to have a macro update these worksheets with the new dates. I don't know if it...
  2. K

    Renaming Worksheet Tabs Macro

    I would like to create a macro that would bring up an input box or preferably a list box that will allow me to input information for a sheet/tab name where where "TBL NPL NGRPL" appears in the code at the end of this message. The macro needs to be available to any new file created...

Some videos you may like

This Week's Hot Topics