Insert Column greyed out as column contains locked cells

[mrbougles]

Hi,

I have got an excel spreadsheet that I have some rows protected in (utilising a macro). Because of the protected rows I can no longer insert new columns as the option is greyed out (because I have protected it against selecting some of the rows) when I right click a column header.

Is there some way that I can modify my macro to allow me to select a column that has protected cells in it? if thats not possible a macro to insert new columns when i click some button would do the job.

My macro is currently like this...

Password = ""
ActiveSheet.Unprotect Password
InsertRowsAndFillFormulas
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:= _
True, AllowFormattingCells:=True, AllowFormattingColumns:=True, _
AllowFormattingRows:=True, AllowInsertingColumns:=True, AllowInsertingRows _
:=True, AllowInsertingHyperlinks:=True, AllowDeletingColumns:=True, _
AllowDeletingRows:=True, AllowSorting:=True, AllowFiltering:=True, _
AllowUsingPivotTables:=True

End Sub

many thanks,

Hugh

 

[VoG]

Maybe you need to supply thee password

 

[mrbougles]

Thanks for the quick response but I dont think that its.

The macro is working pretty well as is and is 99% there.

I click a button and the macro unlocks my sheet, then runs some code (insertrowandfill), then locks it again. When it locks it it stops me from selecting locked cells but still lets me do everything else pretty much.

The only thing is is that because I cant select a locked cell I cans select any row/column or insert any row/column because all rows/columns contain locked cells.

I need my code to allow me to not select a locked&protected cell but allow me to select a column containing a locked&protected cell so that I can insert a column. unless its my something else...