Locked fields

$10-30 USD

Zavřený

Zveřejněno

skoro před 6 roky

$10-30 USD

Zaplaceno při doručení

I've created a tracking spread sheet that reformats when a certification is due for renewal. I've followed the instructions to lock cells (to protect the calculations) but the selected cells won't lock. just the portion outside of the active columns and rows. below are the instructions I use. It works when I create a new spreadsheet, but not after amending. :Highlight cells to remain open Rt click; Format cells; Protection tab. Uncheck "locked"; ok. Review tab; Protect sheet; check "select unlocked cells" all others unchecked. password protect; OK How do I correct this? Using version 2010 Project: All highlighted cells should be locked, all else unlocked.

IČ projektu: 17101853

O projektu

12 nabídky

Vzdálený projekt

Aktivní před 6 roky

Chcete si vydělat nějaké peníze?

E-mailová adresa

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec

Získejte za svou práci zaplaceno

Načrtněte svůj návrh

Registrace a podávání nabídek je zdarma

12 freelanceři nabízejí v průměru $23 USD za tuto práci

@schoudhary1553

Hello, I can help with you in your project Locked fields. I have more than 5 years of experience in Data Entry, Data Processing, Excel, Microsoft, Visual Basic. We have worked on several similar projects before! We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,

$30 USD v 1 dni

4,9

(341 recenze)

8,0

@prameswara

Hello Sir I can locked field like u want in your tracking spreadsheet Sir :) because im excel programer :) please chat me for discuss detail of your project and im able to start working right now Thank You Sincerely Prameswara

$30 USD v 1 dni

4,9

(378 recenze)

7,2

@TechnoGuruu

Hi, I ave multiple years of experience in MS-Excel, functions, macros etc. I have checked your project post, issue and the attached sheet. I will surely assist you with this issue. Please allow me to work on your project. Thanks, Peter

$25 USD v 5 dnech

5,0

(85 recenze)

6,1

@mhfsha

Hello there, Thanks a lot for your job post. I have read your job description very carefully and I am interested to help you in this project, with 5 years of experience of various data entry tasks. I am confident that I can complete the project within the shortest possible of time. I am requesting you to check my portfolios and reviews for further verification. I will be looking forward to hearing from you. Regards, Fathima Saanyia

$25 USD v 0 dni

4,8

(57 recenze)

4,9

@prasannjeetp

Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA and all the functions. I can give a solution of the problem you are getting with locked cells. Please come on chat for more details. Awaiting your response. Thank you.

$30 USD v 1 dni

4,4

(48 recenze)

4,6

@donSene

This easily done by using validation check or can write a simple VBA for this, no need to pay more than 10$ for this simple assignment. can give within one hour or less. please inbox me for more information

$10 USD v 1 dni