Delete Range that is "locked" by code allowing selection of 1 cell only.

**Sircool1** · 04-17-2017, 05:23 PM

Greetings. I have a range of Cells within a Private Sub that is "Locked" by allowing only one cell in that range to be activated at any time.

Please Login or Register  to view this content.

I can not "reset" Range("B24:DS75") by deleting the data entered due to this code. I still require only one cell to be selected for input but need to delete all data entered into the range at completion of the "Job", so fresh data can be entered.

Can someone help with a "workaround" for this?

Thank You.

**scottiex** · 04-17-2017, 06:30 PM

maybe you just want to turn off and on your events like this so the event is not triggered.

Please Login or Register  to view this content.

**Sircool1** · 04-17-2017, 07:05 PM

Thanks Scottiex. Modified to .ClearContents for my needs. Thanks again.

Delete Range that is "locked" by code allowing selection of 1 cell only.

LinkBack

Thread Tools

Rate This Thread

Display

Delete Range that is "locked" by code allowing selection of 1 cell only.

Re: Delete Range that is "locked" by code allowing selection of 1 cell only.

Re: Delete Range that is "locked" by code allowing selection of 1 cell only.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Code Clean-Up: Delete "False" worksheet created when "Cancel" is chosen in Input Box

[SOLVED] Does a vba code "Range("A4")" change if I delete row 2?

[SOLVED] Code that copies row of data to another sheet based on text "Complete"/"Delete"

NEED HELP! Code that copies row of data to another sheet based on text "Complete"/"Delete"

How unlock or delete "locked for editing" files

Macro Error with code "Range("A65536").End(xlUp).EntireRow.Insert"

VBA Code for deleting rows where cell in column a states "delete row"

Bookmarks

Bookmarks

Posting Permissions