Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autonaming tabs
How are you getting the tabs to autoname now?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autonaming tabs
Hey Simon... how it going? Changing it to .Text didn't seem to work... Any other ideas. It's really not that big of a deal. More annoying than anything. UGH! -- Cook ------------------------------------------------------------------------ Cook's Profile: http://www.thecodecage.com/forumz/member.php?userid=107 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=59817 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autonaming tabs
Try using Range("b9").Text instead of Range("b9").Value
-- Rick (MVP - Excel) "Cook" wrote in message ... dan dungan;217711 Wrote: How are you getting the tabs to autoname now? Yes, just need to modify the code to bring the zero over. Here is what I have so far. Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("b9")) Is Nothing Then On Error Resume Next Me.Name = Range("b9").Value If Err.Number < 0 Then MsgBox "Quote sheet has not been named" End If On Error GoTo 0 End If End Sub -- Cook ------------------------------------------------------------------------ Cook's Profile: http://www.thecodecage.com/forumz/member.php?userid=107 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=59817 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autonaming tabs
Exactly what is in B9 and how is the cell formatted?
-- Rick (MVP - Excel) "Cook" wrote in message ... Hey Simon... how it going? Changing it to .Text didn't seem to work... Any other ideas. It's really not that big of a deal. More annoying than anything. UGH! -- Cook ------------------------------------------------------------------------ Cook's Profile: http://www.thecodecage.com/forumz/member.php?userid=107 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=59817 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autonaming tabs
try just Range("b9")
-- Gary K "Cook" wrote in message ... Hey Simon... how it going? Changing it to .Text didn't seem to work... Any other ideas. It's really not that big of a deal. More annoying than anything. UGH! -- Cook ------------------------------------------------------------------------ Cook's Profile: http://www.thecodecage.com/forumz/member.php?userid=107 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=59817 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I alphabetize the tabs on a spreadsheet with 25 tabs? | Excel Worksheet Functions | |||
How do I alphabetize the tabs on a spreadsheet with 25 tabs? | Excel Worksheet Functions | |||
sheet tabs is checked but I can't see my tabs | Excel Discussion (Misc queries) | |||
tabs are missing even though 'tools-options-view-sheet tabs' ok? | Excel Worksheet Functions | |||
hide tabs from view then lock tabs? | Excel Discussion (Misc queries) |