Hi

Is there a way from moving the insert Row/Column function from the tool
bar so that people can't insert Row/Column's into your spreadsheet?

Greg

You can remove them but it is a fair bit of work to ensure that they are
replaced when the book closes or the active window changes... And after all
of that you still have not removed peoples ability to insert by holding down
the shift key while dragging the Cross Hair (Becomes double line with arrows
above and Below) to insert cells or rows or columns. The only effective way
would be to protect the worksheet, but that is not always feasable. If you
still want to proceed with removing the Insert function let me know... I can
get you started, but as I warned you the event handling (not to mention error
handling) is crucial unless your users have a much better sense of humour
than mine do.
--
HTH...

Jim Thomlinson


"Gregc." wrote:

Hi

Is there a way from moving the insert Row/Column function from the tool
bar so that people can't insert Row/Column's into your spreadsheet?

Greg

I would appreciate it if you could get me started.

Thanks

Greg

Insert covers a lot of ground. Do you want to restrict inserting cells, rows,
columns or all of the above? Also can you start a new thread, so I don't have
to keep coming back to this one...
--
HTH...

Jim Thomlinson


"Gregc." wrote:

I would appreciate it if you could get me started.

Thanks

Greg