#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 252
Default worksheets

I haven't done this but I think you can create a "sheet template" such that
whenever a new sheet is added it will be in template form. Can't tell from
your post but you may already be doing this. If so, then all you need to do
is automate the insertion of a new sheet and name it. This works for me:

Sub AddSheet()
Dim ShNum As Integer
If Workbooks("a").Range("A1") = "x" Then
With ActiveWorkbook
ShNum = .Sheets.Count + 1
.Sheets.Add
.ActiveSheet.Name = "Game " & ShNum
End With
End If
End Sub



"ParTeeGolfer" wrote:

Is there a way to automatically insert a new worksheet within a workbook if
data from another workbook equals a certin value. the name the tab from the
last tab number used.

Example:

IF a1 in workbook "a" = "x" thn insert new worksheet from c:/templates
(template Sheet) in workbook B and name it ("Game" #) where # = count tabs
+1

Thanks in advance

Reply
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 use info in Excel shared worksheets to create new worksheets dkc Excel Worksheet Functions 0 June 28th 07 08:36 PM
How do i assign the ActiveWorkbook.Worksheets to a worksheets object? TS Excel Worksheet Functions 2 December 27th 06 02:49 PM
Assigning Cells in worksheets to other data in other worksheets. David McRitchie Excel Discussion (Misc queries) 0 November 27th 04 06:15 PM
Sort Numerically Worksheets via VB when creating a new worksheets John Excel Programming 6 June 1st 04 07:21 AM
Need code to protect worksheets - amount of worksheets varies Sandy[_3_] Excel Programming 1 September 9th 03 02:17 AM


All times are GMT +1. The time now is 07:05 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"