Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there an easy way using VB to change the currently
active sheet's name to a cell value? Scenario: --------- I have a time reporting sheet which uses an employee name validation pulldown to select and show work time statistics for any of my staff. I'd like to create a complimentary VB function which changes the sheet's name to match that of the currently selected employee, preferably via a changed cell action, but I'd settle for creating a button control to accomplish the sheet name change. Any suggestions or code examples would be appreciated Thx - GP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula to match Cell with table of contents | Excel Discussion (Misc queries) | |||
autofit cell height and width to match bitmap contents | Excel Worksheet Functions | |||
change cell contents when pull down menu choices change | Excel Worksheet Functions | |||
Edit macro to match entire cell contents | Excel Discussion (Misc queries) | |||
Lookup cell contents in on sheet based on a formula in second sheet | Excel Worksheet Functions |