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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.