| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting Worksheets
Is there a way to have the workbook count sheets and then have a message pop
up when it reaches a certain number? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Counting Worksheets
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" wrote in message ... Is there a way to have the workbook count sheets and then have a message pop up when it reaches a certain number? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting worksheets in a book | Excel Discussion (Misc queries) | |||
| counting data across worksheets | Excel Worksheet Functions | |||
| Counting Worksheets, Second Verse | Excel Worksheet Functions | |||
| Counting worksheets with a particular name | Excel Programming | |||
| Help with counting across worksheets | Excel Discussion (Misc queries) | |||
Linear Mode
