Excel spreadsheet - locking down VBA and Macros

Selesai Dipasang 3 tahun yang lalu Dibayar saat pengiriman
Selesai Dibayar saat pengiriman

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 untuk Aplikasi Pemrosesan Data Entri Data

ID Proyek: #27549518

Tentang proyek

31 proposal Proyek online Aktif 3 tahun yang lalu

Diberikan kepada:

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 Lebih banyak

$20 USD dalam 2 hari
(4 Ulasan)
3.0

31 freelancer rata-rata menawar $27 untuk pekerjaan ini

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 Lebih banyak

$50 USD dalam 1 hari
(444 Ulasan)
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 dalam 2 hari
(152 Ulasan)
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 Lebih banyak

$14 USD dalam 1 hari
(280 Ulasan)
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 Lebih banyak

$30 USD dalam 2 hari
(73 Ulasan)
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. Lebih banyak

$15 USD dalam 1 hari
(100 Ulasan)
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 Lebih banyak

$25 USD dalam 1 hari
(74 Ulasan)
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 Lebih banyak

$25 USD dalam 1 hari
(41 Ulasan)
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 dalam 1 hari
(47 Ulasan)
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 Lebih banyak

$20 USD dalam 2 hari
(10 Ulasan)
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 dalam 1 hari
(28 Ulasan)
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 dalam 2 hari
(40 Ulasan)
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 Lebih banyak

$20 USD dalam 1 hari
(6 Ulasan)
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 dalam 1 hari
(1 Ulasan)
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 dalam 7 hari
(2 Ulasan)
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 Lebih banyak

$20 USD dalam 2 hari
(1 Ulasan)
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, Lebih banyak

$10 USD dalam 1 hari
(1 Ulasan)
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 Lebih banyak

$10 USD dalam 2 hari
(0 Ulasan)
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 dalam 1 hari
(0 Ulasan)
0.0