View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pamela[_3_] Pamela[_3_] is offline
external usenet poster
 
Posts: 8
Default Where do I add this Macro

Hi Guys!!!
I got this macro that adds a password to a spreedsheet:
=============
Private Sub Workbook_Open()
'If you have different passwords
'for each Worksheet.
Sheets(1).Protect Password:="Secret", _
UserInterFaceOnly:=True


Sheets(2).Protect Password:="Carrot", _
UserInterFaceOnly:=True


'Repeat as needed.
End Sub
===============

But I don't where to write the macro to make it work.
please help me,
Pamela XoXo