Thread: Apply Macro to all worksheets in a workbook except one
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
  
Posts: 2,722
Default Apply Macro to all worksheets in a workbook except one
Sub Apply_to_all_sheets()

For Each ws In Worksheets
If ws.name = "Sheet1" then goto xSkip
Call Begin
xSkip:
Next
End Sub

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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