Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Protection
Hi. I have a macro that is activated on any Worksheet
Change. I would like to protect this sheet so that the user will only enter data in the appropriate cells. When I protect the sheet, however, I get an application error. The application error occurs when the macro attempts to delete a shape ... Any ideas? Thanks, Mike. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Protection
Mike,
Use the UserInterfaceOnly parameter when you protect the sheet. This allows VBA code to do anything to the sheet; it only protects against use action with the keyboard and mouse. E.g., Worksheets(1).Protect UserInterfaceOnly:=True -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Mike" wrote in message ... Hi. I have a macro that is activated on any Worksheet Change. I would like to protect this sheet so that the user will only enter data in the appropriate cells. When I protect the sheet, however, I get an application error. The application error occurs when the macro attempts to delete a shape ... Any ideas? Thanks, Mike. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet Protection
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 "Mike" wrote in message ... Hi. I have a macro that is activated on any Worksheet Change. I would like to protect this sheet so that the user will only enter data in the appropriate cells. When I protect the sheet, however, I get an application error. The application error occurs when the macro attempts to delete a shape ... Any ideas? Thanks, Mike. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Protection Best Practice: AKA: Real Sheet Protection | Excel Discussion (Misc queries) | |||
Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
Sheet protection | Excel Discussion (Misc queries) | |||
sheet protection | Excel Discussion (Misc queries) | |||
Sheet protection | Excel Programming |