Adding columns when w/s is protected

T

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?
 
G

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
 
Top