PC Review


Reply
Thread Tools Rate Thread

Counting Worksheets

 
 
=?Utf-8?B?am5mNDA=?=
Guest
Posts: n/a
 
      14th Sep 2007
Is there a way to have the workbook count sheets and then have a message pop
up when it reaches a certain number?
 
Reply With Quote
 
 
 
 
Mike Fogleman
Guest
Posts: n/a
 
      14th Sep 2007
Something like this put in the ThisWorkbook code module:

Private Sub Workbook_NewSheet(ByVal Sh As Object)
If Sheets.Count > 3 Then MsgBox "Too many sheets."
End Sub

Mike F
"jnf40" <(E-Mail Removed)> wrote in message
news:B55144E1-E4A8-45D2-A4B9-(E-Mail Removed)...
> Is there a way to have the workbook count sheets and then have a message
> pop
> up when it reaches a certain number?



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting worksheets with a particular name =?Utf-8?B?RnJlZGRpZSBNYWM=?= Microsoft Excel Programming 9 30th Jun 2006 01:37 PM
Counting across worksheets Pelham Microsoft Excel Discussion 2 17th Aug 2005 09:55 AM
Help with counting across worksheets Biff Microsoft Excel Misc 4 12th Apr 2005 04:16 AM
counting across multiple worksheets =?Utf-8?B?R29yZG9uIFdhbHNo?= Microsoft Excel Misc 3 9th May 2004 09:10 PM
Counting No of Worksheets Rajujay Microsoft Excel Worksheet Functions 1 7th May 2004 01:46 PM


Features
 

Advertising
 

Newsgroups
 


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