VBA code required to restricted column editing

**arindamsenaxa** · 06-23-2021, 12:26 AM

Hi All
Just wanted to know how I can restrict the edit option for a blank column and this restriction should be activated once I entered something for the first time.

As an example in the attached excel
1) Under request ID if I put any numeric data for the first tie then I should not have access to edit the same field for the 2nd time
2) Once I update something in the "Request" column the "Date" and "Time" column should get the update automatically and capture the entry date and time
If anyone suggests me some code it will be very helpful.

help.xlsx

Regards
Arindam

**6StringJazzer** · 06-23-2021, 10:02 AM

I am going to suggest you manage this using protection and locked cells. The Request ID column starts out unlocked. Then when the user enters numeric data, it is locked. I added Data Validation to require numeric data (whole number greater than 0), since you specified that.

**arindamsenaxa** · 06-23-2021, 11:45 PM

Hi @6StringJazzer

Regarding the title question of mine what you have given the solution it's perfectly working fine for me.
Just need one more help
For some time I need to delete all the data from the Sheet so if you can add a shortcut key to refresh the page so that I can make the whole page blank for next month's use.
It will be a great help if you can tell me how to do that.

Regards
Arindam

VBA code required to restricted column editing

LinkBack

Thread Tools

Rate This Thread

Display

VBA code required to restricted column editing

Re: VBA code required to restricted column editing

Re: VBA code required to restricted column editing

Thread Information

Users Browsing this Thread

Similar Threads

VBA code Help PAssword with restricted viewing

[SOLVED] Help editing VBA code that uses MySQL queries to show also column names

[SOLVED] code editing, inserting from three conditions into one more column

[SOLVED] Message Box pop up VBA not working in Restricted Editing mode.

[SOLVED] VBA Code Required to autofill formulated column according to the adjacent column

Editing code to show common four-word combinations in a column

[SOLVED] Help required to code a '% of total' column

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions