The work-sheet "celldel" code is as below. It disallows row 'insert' and 'delete' methods by using right click on the Row Number bar (left side) and then choosing either Insert or delete. The change that I want to do, is allow insert and disallow delete method.
Thanks and best regards
Vilas Desai
Please Login or Register to view this content.
I pasted your code into a worksheet module, but none of it gets triggered when I delete or insert rows or columns. Am I missing something?
Acts 4:12
Salvation is found in no one else, for there is no other name under heaven given to mankind by which we must be saved.
OK, here is the worksheet change event code. This goes into the worksheet MasterList!
The earlier code is a "Class Modules" code
Regards
Vilas Desai
Please Login or Register to view this content.
Ok, I pasted that code into a Class Module, and the earlier code into Sheet1, but still nothing happens when I insert or delete.
Have you named the Sheet1 as MasterList -- sorry to ask this question but sometimes it is missed out as i usually do.
Yes, but it doesn't make any difference. I put debug stops in all the class module subroutines, but not of it is being run. I don't have much experience with class modules, so I'm probably doing something wrong. Sorry. Maybe someone else can help.
the code doesn't stop inserting or deleting-only clearing contents. not real clear what the problem is
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks