Hello, is there a way to prevent users from Deleting and Inserting Rows/Columns without protecting the Worksheet?
The reason I don't want to protect the worksheet is because when someone pastes something into my worksheet, it defaults it to "locked" and then they are unable to use the cell again.
I know that there is no workaround with "Match Destination Formating as Default" with "Ctrl + V". I have been using a marco for Ctrl +D.
Last edited by johnph; 07-19-2012 at 03:44 PM.
To answer your question; yes and no.
You can actually completely modify a user's ability to edit based on their overall Excel settings. However, you will have to invoke these properties when you're workbook is active/open, and revert them back to the user's former settings when other workbooks are opened/viewed. I do not recommend changing a user's settings as any errors in your programming could cause them to lose their original settings, etc.
You can actually edit any shortcut key as well - for example to disable ctrl+v from doing anything you can use the following:
Note: the ^ (carrot) key represents "control" and the {v} represents the literal keyboard character v. Basically the comand sets the shortcut command to run "" (nothing);
Please Login or Register to view this content.
Yeah, figures. I can live with Ctrl + D for now. Is there any way to prevent them from deleting and inserting ROWS/COLUMNS?
To prevent insertion, put "x" in Cells(Rows.Count, Columns.Count)
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
What do you mean by putting "X" in cells(row.count, columns.count). Sorry I am a bit lost.
If you put anything in the far right column and try to insert a column, Excel won't do it. I will not move data off the edge of the spreadhsheet. Run this code and then try to insert either an entire column or an entire row. You won't be permitted.
That will allow the user to insert individual cells, just not whole columns or whole rows.Please Login or Register to view this content.
To forbid any insertions
Note that this doesn't effect deletions.Please Login or Register to view this content.
wow great trick haha, is there any way to prevent deletion? Thanks Mike
Maybe perhap hide the delete and insert feature with
Does excel 2007 have something like this?Please Login or Register to view this content.
My problem is the reverse of this. I have successfully locked 4 cells in my worksheet, but the step of protecting the worksheet means I can no longer insert rows (which are unaffected by the cell locking).
Therefore my question is:
How do I insert rows in a protected worksheet?
Depending on your version of Excel, the Protection dialog will include checkboxes about what is permitted on a protected sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks