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

Where do I add this Macro
 

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

--

"Pamela" wrote in message
...
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

Where do I add this Macro
 

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

On Mon, 12 Jan 2009 11:33:46 -0800 (PST), Pamela
wrote:

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

Where do I add this Macro
 

On Jan 12, 12:11*pm, Gord Dibben <gorddibbATshawDOTca wrote:
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

On Mon, 12 Jan 2009 11:33:46 -0800 (PST), Pamela
wrote:



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- Hide quoted text -

- Show quoted text -

THANK YOU!!!!