Excel spreadsheet - locking down VBA and Macros

Completado Publicado hace 3 años Pagado a la entrega
Completado Pagado a la entrega

I have a spreadsheet and I need it locked so that the user can only click on certain fields. It has VBA macros and if you lock it gives 104 error. I need the code locked but I need it to work properly when locked and the VLOOKUP and VBA macros is running.... no errors.

I need it locked and protected...but I also need the spreadsheet Macros to work when locked.

Look at Concept1 picture.

Color Green cannot touch or edit while password protected.

Color Yellow - be able to use VBA but have it locked so nothing can mess it up. Want password protected but still be able to use check boxes

Color White - Open and unlocked always.

Thanks,

Excel Visual Basic Visual Basic para aplicaciones Procesamiento de datos Entrada de datos

Nº del proyecto: #27549518

Sobre el proyecto

31 propuestas Proyecto remoto Activo hace 3 años

Adjudicado a:

RTYSDAL

Although I am relatively new to Freelancer, I have 25 years experience developing Excel, Access and VBA Scripts for a major computer corporation.  I have reviewed your project and would like to recommend a solution tha Más

$20 USD en 2 días
(4 comentarios)
3.0

31 freelancers están ofertando un promedio de $27 por este trabajo

schoudhary1553

Hi, Greetings! ✅checked your project details: Excel spreadsheet - locking down VBA and Macros ✅Completed Time: In project deadline We have worked on 650 + Projects. I have 6 + years of the experience in same kin Más

$50 USD en 1 día
(444 comentarios)
8.3
finecodervw

Hi, As I understand you need VBA and VLookup to work in the locked sheet. Please share the Excel sheet you have. Looking forward to your response. Thanks

$30 USD en 2 días
(152 comentarios)
6.6
AnowarRatul

------- 5 ***** ---------EXCEL EXPERT-------------I CAN START RIGHT AWAY------------- Hello sir, I have read your project details carefully. I can make a VBA Macro Code to VBA LOCK by maintaining 100% accuracy of your Más

$14 USD en 1 día
(280 comentarios)
6.4
narsim3128

NOTE : I HAVE EXPERTISE IN EXCEL AND VBA. I CAN COMPLETE THIS TASK IN QUICK TIME. With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT expe Más

$30 USD en 2 días
(73 comentarios)
6.1
ravinderkumar248

Hi there, I can lock your vba script , and it will work in when locked. I am excel vba expert and have 10 yaers of experince in creating automation , database, query, macros etc. Please message me to discuss more. Más

$15 USD en 1 día
(100 comentarios)
5.7
paulodayto08

Hi, Good Day! I can help you fixing your spreadsheet and locked it and keep the vba macro running. I can't open the attached file, can you message me and let's discuss more about the project and I can also send you so Más

$25 USD en 1 día
(74 comentarios)
5.5
yadavexpert53

Hi, I can assist you in the best way & according to project requirement. I am an expert and professional in MS Excel & VBA. It includes extracting information from text files, websites, transferring info in to excel, U Más

$25 USD en 1 día
(41 comentarios)
4.8
nurnga1218

Hi, Can you send me your file. I'm sure I can do it shortly. I'm a macro VBA expert and I have many experiences on it. Waiting your reply. Thanks

$20 USD en 1 día
(47 comentarios)
4.8
FaiziTechy

This is quite simple work Hi, I am Excel VBA expert having 7+ years of experience My works includes: 1. Project Dashboards, Employee tracker 2. Userforms, Automated calculations, pivots and graphs 3. Data consoli Más

$20 USD en 2 días
(10 comentarios)
4.5
rameshraja86

Hi I can protect your sheet, any specific cells with password with all other functions like macros and formulas working. I can provide change password option too Pls contact me for further discussions

$30 USD en 1 día
(28 comentarios)
4.7
maguirrer

Hello, I can help you to lock your sheet on specific cells, please send me a message with more details and I will start working on it inmediately

$27 USD en 2 días
(40 comentarios)
4.4
Mohilm007

--------------------I CAN START RIGHT AWAY 100% ACCURACY-------------------------------- Hello sir, I have read your project details . I can Automated Data Analysis via Excel spreadsheet by maintaining 100% accuracy Más

$20 USD en 1 día
(6 comentarios)
3.7
mmartinezruiz96

Hi, I am an industrial engineer with 3 years of experience who is proficient in VBA. I can fix it in less then 1 hour, since this is quite straightforward for me. Best Regards, Marc

$14 USD en 1 día
(1 comentario)
2.5
absrads

Hello, Yes, this can be done. Pls share the sample file to work on an present a demo to you. Thanks. AJ

$45 USD en 7 días
(2 comentarios)
1.9
iceman0k

Hi, I have substantial experience in Excel leveraging VBA to automate daily mundane tasks. I can help with your problem. Lets connect and discuss in detail. Looking forward to a fruitful relationship. Regards Varinde Más

$20 USD en 2 días
(1 comentario)
1.1
khanbijoymbk2020

Expert on Advance Excel ✅ Hi there! I’m bijoy, my computer experience is 13 year's more. I’m expert on Data Entry, VBA, Macro, Data Validation, Conditional Formatting, Forecast, Pivot Table, Graph and Chart, Dashboard, Más

$10 USD en 1 día
(1 comentario)
0.0
hossen116122

I am working as a product Management Engineer at a multinational company. I already have some sheet that have VBA & Macros and it is locked successfully. Let's have a meeting tomorrow night to discuss that if you accep Más

$10 USD en 2 días
(0 comentarios)
0.0
DNash1

I have dealt with the 1004 run time error before due to locked cells and have fixed the issue. I'm new to freelancer but I have years of experience with this.

$30 USD en 1 día
(0 comentarios)
0.0