PDA

View Full Version : [SOLVED] Disable right click insert rows



blackie42
08-26-2016, 06:27 AM
Hi Guys,

Don't want users to insert rows in the middle of a spread-sheet using 'right click insert' - any ideas how to achieve this?

Many thanks
Jon

p45cal
08-26-2016, 09:50 AM
Password protect the sheet and tick everything except Insert Rows in the Allow all users of this worksheet to: box.

You can also prevent users inserting entire rows by putting an array-entered formula across the rows concerned, somewhere out of the way, say several hundred or thousand columns the the left. A formula such as ="" array-entered (entered with Ctrl+Shift+Enter)in cells BB3:BB14 will cause a popup to appear if the user tries to insert entire rows in rows 3 to 14 - that message being 'You cannot change part of an array'

blackie42
08-31-2016, 02:37 AM
Thanks for your help P45 - protecting sheet seems best way to go

regards
Jon