Adding columns when w/s is protected

[tmacke]

Hi. I have a protected worksheet setup to allow data entry to a specific
group of cells in sequential rows. I would like the user to have the
capability to add rows when necessary. Is there a macro button I can
create to allow the user to add rows with the same format as the row
above it, without copying the data? Does anyone have another solution?

 

[Frank Kabel]

Hi
record a macro while protect and unprotect a sheet to see the required
code

 

[Gord Dibben]

If using Excel 2002 or 2003 you have the option when protecting the sheet of
allowing users to insert rows and columns.

Earlier versions would require a macro to unprotect then re-protect the sheet.

ActiveSheet.Unprotect Password:="justme"

'insert the rows and formatting

ActiveSheet.Protect Password:="justme", DrawingObjects:=True, _
Contents:=True, Scenarios:=True





OR the use of UserInterfaceOnly

..Protect Password:="ABC", DrawingObjects:=True, _
Contents:=True, Scenarios:=True, UserInterfaceOnly:=True


Gord Dibben Excel MVP