| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need help to update macro to office 2007 macro enabled workbook | Excel Discussion (Misc queries) | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
| Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
![Pamela[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
