Thread: Sub to freeze all sheets & delete all comments
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
  
Posts: 9,101
Default Sub to freeze all sheets & delete all comments
For Each sht In Sheets
sht.Cells.Copy
sht.Cells.PasteSpecial past:=xlPasteValues

Next sht


"Max" wrote:

Hunting for a sub to freeze all sheets (copy entire sheetpaste special as
values) & delete all comments (in all sheets) in a book. Thanks.
Reply With QuoteReply With Quote