Excel VBA Macro- Locking cells after data entry

A small VBA work. Very urgent. Just 1 hour.

A * Need two options in J8 till end (downwards) - Combobox

1. Accepted

2. Rejected

B After Selecting any of the above, that particular cell should be locked and can be unlocked and edited only by providing password set by admin

C Column H and I should be locked always. But admin should be able to edit it anytime with password

D Upon selecting Accepted or Rejected on each row, Total Count mentioned on left side should reduce after data entry.

Eg: In this sheet total count is 106, if I select J7 as accepted or rejected, then total count should show 105 and so on.

E Same should be applied to all sheets in this worksheet

See the attachment

Aptitudini: Excel, Excel VBA

Vezi mai multe: lock a cell after data entry using vba excel with message box notification before locking, vba lock cells, excel data entry form protected sheet, how to lock or protect cells after data entry or input in google sheet, auto-lock-cells-after-data-entry excel sheets, lock cells after today's date passed excel, how to lock or protect cells after data entry or input in excel?, how to lock cells in excel, excel vba macro paste adjacent column, excel vba paste csv cells, paste excel vba macro, updating excel vba workbooks without changing data, excel vba macro databases, excel vba macro programming bids, script excel spreadsheet macro read cells, excel vba macro calculate business days, excel vba macro find text morld, generate report excel vba macro, excel vba macro optimization, excel vba macro protect cell

Despre angajator:
( 15 recenzii ) Kottayam, India

ID Proiect: #19772603

Acordat lui:


Hello there, I am an Excel coder and I can create 1 script do do this task for you. It will take from 30-45 mins so please contact me now. Thank you.

%selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD în 1 zi
(84 Recenzii)

11 freelanceri licitează în medie 20$ pentru acest proiect


Hello. I can handle almost everything in excel. I am willing to take this job. I ll do the sheet first, you can review and then award the project for payment. Understood t he project requirements and ready to start.

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(23 recenzii)

Hi Good Day! A serious freelancer here. I've done a lot of excel macro work which part of my daily tasks as a Project Management Officer. I can help you with this project. Please consider my bid. With my exper Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 0 zile
(25 recenzii)

Hi. 1. I am an expert in Excel(VBA), Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for f Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(3 recenzii)

Hello, I have just gone through your requirement. I understand your requirement completely and I can do your work and I am able to Start ASAP. Check out my works: Belliza Designer Studio:-[login to view URL] Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(0 recenzii)

I am Neha C. I am a Web Developer and have 5+ experience in VB,ASP.Net,Excel,SQL,Oracle. I have hands on experience on Excel macros and VBA.I like doing challenging work and I always complete my commitments. I gone Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)

hi sir i am professional dat entry i am willing to work your project.. hoping for i am the one you choose [login to view URL] you

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(0 recenzii)

Hi, We have gone through the file and we would be able to get the work done for you. We can introduce a dropdown in column J for all the rows to select either Accepted or Rejected and rest of the functionalities can al Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)

I am good at excel.I always use excel for my projects form my school days so i will complete your work in minimum hours. Thank you..

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 0 zile
(0 recenzii)

I will work properly and take all responsibility

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)

I need the VBA experience, so I am going to try my hand at it regardless of being paid / accepted

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 5 zile
(0 recenzii)