Is it possible to have a cell, that is linked to the sheet name. So if the I were to type in 'Sheet 1' in the link cell, the sheet would automatically change its name to 'Sheet 1'?
Is it possible to have a cell, that is linked to the sheet name. So if the I were to type in 'Sheet 1' in the link cell, the sheet would automatically change its name to 'Sheet 1'?
Put this in the worksheet code module
![]()
Please Login or Register to view this content.
Elegant Simplicity............. Not Always
Hi, dompoma,
some more restrictions on the sheetname here (code goes behind the worksheet, right-click worksheet tab, choose View Code, paste into the code window):
Ciao,![]()
Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks