Thread: Password Protecting an Attachment sent via VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Casey[_119_] Casey[_119_] is offline
external usenet poster
  
Posts: 1
Default Password Protecting an Attachment sent via VBA

John,

Try something like:

Dim AnySheet As Worksheet

For Each AnySheet In ActiveWorkbook.Worksheets
ActiveWorkbook.Worksheets(AnySheet.Name) _
.Protect Password:="mypassword"
Next


HT

--
Case

-----------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...nfo&userid=454
View this thread: http://www.excelforum.com/showthread.php?threadid=56219

Reply With QuoteReply With Quote