Thread: Tom Ogilvy
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
halem2[_26_] halem2[_26_] is offline
external usenet poster
 
Posts: 1
Default Tom Ogilvy

Hi Tom:

a few pages back you helped me with this macro to clean several sheet
by calling a macro called ClearSheet.

Sub CleanAllSheets()
For Each sh In ActiveWorkbook.Worksheets
sh.Activate
ClearSheet
Next
End Sub

I have a sheet in the workbook that is protected and the macro fail
when it gets to it. How can I run it on all sheets except on a shee
called FORM?

thanks a million..

--
Message posted from http://www.ExcelForum.com