Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting rows into worksheets that are protected
I am trying to insert (or delete) rows in a worksheet that I have
protected in order to prevent certain cells being altered. Once I have locked the specific cells, and protected the sheet, the options to "Insert" or "Delete" rows is greyed out. Can anyone offer a solution? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting rows into worksheets that are protected
with XP or 2003 you can choose exactly what you protect.
with 2000 or before, when you protect the sheet, you can't do anything. so solution would be not to protect it to insert rows. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting rows into worksheets that are protected
Very new to this and could not find my anser by searching.
I have the same need, but with 2003. My catch is that I want to make the change in a macro. See below: With Worksheets("Clarence") .Protect Password:="qsi", userinterfaceonly:=True .EnableOutlining = True .EnableAutoFilter = True End With What is the setting for inserting and deleting rows in a macro like this? Must be something like Enableoutlining. "tiah" wrote: with XP or 2003 you can choose exactly what you protect. with 2000 or before, when you protect the sheet, you can't do anything. so solution would be not to protect it to insert rows. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Inserting rows into worksheets that are protected
Here is all the code you can put to protect in 2003
Worksheets("Clarence") .Protect DrawingObjects:=False, _ Contents:=True, Scenarios:= False, AllowFormattingCells:=True, _ AllowFormattingColumns:=True, AllowFormattingRows:=True, _ AllowInsertingColumns:=True, AllowInsertingRows:=True, _ AllowInsertingHyperlinks:=True, AllowDeletingColumns:=True, _ AllowDeletingRows:=True, AllowSorting:=True, AllowFiltering:=True, _ AllowUsingPivotTables:=True |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting Rows | Excel Discussion (Misc queries) | |||
macro to hide rows across several worksheets fails | Excel Discussion (Misc queries) | |||
protection and inserting rows | Excel Worksheet Functions | |||
inserting specific # of rows | Excel Discussion (Misc queries) | |||
Adding rows of different info from separate worksheets into summar | New Users to Excel |