edit ranges

Hi all, after posting in various forums trying to find a solution for my problem, searching google for hours, I am coming here to see if anyone can help me with this situation I am stuck in at work. If someone can fix this problem for me, you will end the heartache I've had for the last 5 days...

Hi all, I'm trying to lock down table edits but need to allow sorting AND executable hyperlinks.. Please help, can't find a solution that works for both. 'Allow Users to Edit Ranges' + all cells locked -> allows sorting but can't click the cells with hyperlinks 'Allow Users to Edit Ranges' +...

Hi Guys, Hope you can help. Do you know how to use a range named (with offset formula) when restricting access with Allow user to Edit Ranges. For some reason, as soon as I used an offset formula or a named range with an offset, the dynamic range is automatically converted to a hard coded...

Hi. I am using the worksheet open event as the trigger to copy and paste editable ranges from other worksheets into a 'summary sheet' but I do not want users to be able to edit the ranges in the resultant 'summary sheet'. I can get the data okay but the open event seems to be causing looping...

Longtime fan, first time poster; apologies if I somehow messed up thread etiquette. Using Excel 2010. For various reasons which aren't worth going into (basically I need to protect/lock an entire table with the exception of one column, but still allow sorting) I need to make use of Excel's...