Thread: Apply Macro to all worksheets in a workbook except one
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Tom Hutchins Tom Hutchins is offline
external usenet poster
  
Posts: 1,069
Default Apply Macro to all worksheets in a workbook except one
Try

For Each ws In Worksheets
If ws.Name < "Sheet1" Then
Call Begin
End If
Next

Hope this helps,

Hutch

"Carrie_Loos via OfficeKB.com" wrote:

Is there a way to include an exception to this macro so that it excludes
Sheet1??

Sub Apply_to_all_sheets()

For Each ws In Worksheets
Call Begin
Next
End Sub

Thanks for any help
Carrie

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200901/1


Reply With QuoteReply With Quote