+ Reply to Thread
Results 1 to 1 of 1

Rename and hide/unhide worksheets based on cell entry

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2007

    Rename and hide/unhide worksheets based on cell entry


    I have a workbook which will be used to track sales performance of staff. It has an entry sheet for staff names, employee number, hours etc. Names are entered in cells A5, A6, A7 and so on.
    I need the entry in each cell to rename a worksheet and unhide it. If the cell has data the sheet becomes visible, if it is blank then the sheet is hidden.
    Also, cell A1 on each sheet then needs to show the name of that worksheets tab.

    The names in the entry sheet may also change on a regular basis so I need the code to refer to the codename of the sheet and allow renaming. Also if it can update the sheet with changes or a macro button can be added if more suitable.

    The idea is so that the Entry sheet is pretty much the only sheet the user needs to deal with but should allow me to create more sheets if needed just by extending the code (that is why A1 on each sheet refers to the tab name, not the cell on the entry sheet)

    Attached is a very basic sample and the requirements
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1