UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> New worksheet    
 
   
joe081796
post Jul 6 2004, 10:54 AM
Post #1

UtterAccess Veteran
Posts: 475
How can I insert a worksheet with a name of my choosing?

thanks,
Joe
Go to the top of the page
 
+
 
 Start new topic
Replies (1 - 6)
cmpgeek
post Jul 6 2004, 10:57 AM
Post #2

UtterAccess Veteran
Posts: 337
From: Athens Georgia USA
you would first choose INSERT -> WORKSHEET from the verb bar at the top of the window, then double click on the name of the tab. this should highlight the name and allow you to rename it...

hth...
Go to the top of the page
 
+
joe081796
post Jul 6 2004, 11:06 AM
Post #3

UtterAccess Veteran
Posts: 475
I'm sorry, I didn't type what I meant. I'd like to be able to do this via code. I've not been able to locate any examples on how to have the new sheet have a name other than the system generated one. Any ideas?

thanks,
Joe
Go to the top of the page
 
+
cmpgeek
post Jul 6 2004, 11:11 AM
Post #4

UtterAccess Veteran
Posts: 337
From: Athens Georgia USA
i am not real good with Code, but check this place out - maybe rhey can help you:

VBA Express


hth...
Go to the top of the page
 
+
Clippit
post Jul 6 2004, 11:22 AM
Post #5

UtterAccess VIP
Posts: 3,645
From: Near Toronto, ON, CA
This line of code adds a worksheet to the active workbook speciying a worksheet name:

Application.ActiveWorkbook.Worksheets.Add.Name = "MyNewName"
Go to the top of the page
 
+
joe081796
post Jul 6 2004, 11:28 AM
Post #6

UtterAccess Veteran
Posts: 475
Thank you both, I really appreciate it. This worked great.

Joe
Go to the top of the page
 
+
Clippit
post Jul 6 2004, 11:52 AM
Post #7

UtterAccess VIP
Posts: 3,645
From: Near Toronto, ON, CA
You're welcome.
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Switch to: Standard · Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th May 2013 - 03:29 PM