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