| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA changing Page Name.
Hello Does someone know how to get a VBA to change a page name according to the value in a cell. The reason why I ask this is because I have a database with many names and after entering a new name I must go to a Template sheet enter their ID number in cell D1 and then change the page name. And what I want is the sheet name to be equal to their ID Number. Paul Maynard Moscow Russia -- paulrm906 ------------------------------------------------------------------------ paulrm906's Profile: http://www.excelforum.com/member.php...o&userid=28776 View this thread: http://www.excelforum.com/showthread...hreadid=520578 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA changing Page Name.
Worksheets("Sheet1").name = Range("A1").value
HTH -- AP "paulrm906" a écrit dans le message de ... Hello Does someone know how to get a VBA to change a page name according to the value in a cell. The reason why I ask this is because I have a database with many names and after entering a new name I must go to a Template sheet enter their ID number in cell D1 and then change the page name. And what I want is the sheet name to be equal to their ID Number. Paul Maynard Moscow Russia -- paulrm906 ------------------------------------------------------------------------ paulrm906's Profile: http://www.excelforum.com/member.php...o&userid=28776 View this thread: http://www.excelforum.com/showthread...hreadid=520578 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing default Page Setup | Excel Discussion (Misc queries) | |||
| Add page numbers to multiple worksheets without changing page setu | Excel Discussion (Misc queries) | |||
| How do I keep someone from changing page breaks on a sheet that i | Excel Worksheet Functions | |||
| Changing pivot table Page | Excel Programming | |||
| Changing Page Headers with Variables | Excel Programming | |||
Linear Mode
