On Thursday, June 26, 2014 10:34:49 PM UTC+1, GS wrote:


I wasn't referring to 'protect shared workbook'! You can apply sheet



protection to a shared workbook, which doesn't have anything to do

with



'protect shared workbook'!





Hi Garry,



Won't this also disable the insert rows function? I need to be able

to keep the ability to insert Rows and delete rows and just disable

the hide row functions.



Look at the options in the 'protect sheet' dialog to see all what you

can allow. Certainly 'anything' is possible if your project manages

data table rows/cols via VBA. This is how I handle protected sheets

because it ensures that when users insert/delete rows/cols the

worksheet's 'design structure' doesn't get 'broken'! Otherwise, if your

project's worksheets don't implement a 'design structure' then all bets

are OFF!

Hi Garry,

This is not a question of preserving structure, the code I have written is not dependent on specific row numbers etc. I just need to prevent more advanced users from hiding rows of data that less experienced users are having difficulty locating and unhiding again.