Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a Macro with the sheet protected.
How do I use a macro and have the sheet protceted at the same time.
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a Macro with the sheet protected.
Protect your worksheets with code with userfaceonly like this
Place this in the Thisworkbook module. The macro's will be working now It will only protect the userfaceonly Right click on the Excel icon next to File in the menubar And choose View code You are now in the Thisworkbook module Paste the Event in this place Alt-Q to go back to Excel Private Sub Workbook_Open() Dim sh As Worksheet Application.ScreenUpdating = False For Each sh In ThisWorkbook.Worksheets sh.Protect "ABCD", , , userinterfaceonly:=True Next sh Application.ScreenUpdating = True End Sub -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "Jason Watts" wrote in message ... How do I use a macro and have the sheet protceted at the same time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro & Protected sheet | Excel Discussion (Misc queries) | |||
how to enable a macro in protected sheet | Excel Discussion (Misc queries) | |||
macro on protected sheet-error | Excel Discussion (Misc queries) | |||
use macro button to run macro in protected sheet | Excel Discussion (Misc queries) | |||
Macro Errs when sheet is protected | Excel Worksheet Functions |