LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Creating New work sheets and assigning names automatically


Is it ****ible with VBA excel to create a new worksheet and assign to i
a name automatically?

Basically I have a button which runs a piece of VBA code which include
creating a new worksheet. Ideally when i click on that button Exce
would know thaht the worksheet to be created should have a particula
name such as "ABC" instead of "sheet1", "sheet2" etc

thank

--
paz2
-----------------------------------------------------------------------
paz24's Profile: http://www.excelforum.com/member.php...fo&userid=3104
View this thread: http://www.excelforum.com/showthread.php?threadid=50718

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i compare and remove common names from 2 excel work sheets Andrew Excel Worksheet Functions 0 April 8th 10 09:02 AM
Work sheets tab names only replace part ot the present name John Augustein Excel Worksheet Functions 2 October 4th 09 06:09 PM
Assigning set of range names ADB Excel Programming 5 September 25th 05 11:45 AM
Automatically creating file names TLerman Excel Discussion (Misc queries) 0 September 3rd 05 02:56 PM
creating sheets with names from cells masseysmate Excel Programming 1 June 30th 05 03:06 PM


All times are GMT +1. The time now is 12:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"