Where do I add this Macro

[Pamela]

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

 

[PCLIVE]

Alt+F11 to open the VBEditor. Then double-click "ThisWorkbook". Paste code
in right-hand pane. That should do it.

 

[Gord Dibben]

It is workbook event code.

Right-click on the Excel left of "File" on the menubar or on Excel Icon at
left end of Title bar if your window is not maximized.

Select "View Code" to open Thisworkbook Module.

Paste the code into that module.

Alt + q to return to the Excel window.

Save, close and re-open the workbook.


Gord Dibben MS Excel MVP

 

[Pamela]

It is workbook event code.

Right-click on the Excel left of "File" on the menubar or on Excel Icon at
left end of Title bar if your window is not maximized.

Select "View Code" to open Thisworkbook Module.

Paste the code into that module.

Alt + q to return to the Excel window.

Save, close and re-open the workbook.

Gord Dibben  MS Excel MVP






- Show quoted text -

THANK YOU!!!!