Completed

Help me with my VBA code in Excel -- 2

Hi,

I need help getting my VBA code to work in Excel.

I want to prevent users copy and pasting where I have drop-down menus in my Excel file and have successfully written code that triggers an error message. However, it doesn't work when the sheet is protected. I need to protect the sheet so that users can't add/delete rows, columns etc. I want the protection to include a password.

I need a freelancer who can correct my code and explain why my attempt isn't working. So far two freelancers have tried but not been successful.

Many thanks.

Skills: Excel, Excel VBA, Excel Macros

See more: compare vba code excel workbooks, optimisation vba code excel, financial vba code excel, vba code excel data analysis, vba code excel increment, ftp user vba code excel, vba code excel ftp download, view vba code excel, simplex method vba code excel, vba code excel 2007, vba code excel create clock, extract vba code excel, protect vba code excel dll, nelder mead vba code excel, vba code excel data word table, vba code excel

About the Employer:
( 0 reviews ) Hägersten, Sweden

Project ID: #31911777

Awarded to:

(100 Reviews)
5.8

17 freelancers are bidding on average $36 for this job

(428 Reviews)
8.3
(229 Reviews)
7.1
AccountantArman

Sir, I am Excel VBA, Excel macros, Excel dashboard Advance Level Expert. This is a basic work for me. i can complete this project with added quality. About me I am Chartered Accountant with more than 4 years of exper More

$20 USD in 2 days
(113 Reviews)
6.0
Valuesolutions

Hello, I hope this finds you well. I have just seen your project requiring; Excel Excel VBA Excel Macros I believe that my 10-year experience in this field is what you need right away. Avoid the headache of looking f More

$200 USD in 4 days
(7 Reviews)
4.2
varimaxanalytic

Hey! I am really interested in this job. I’m data scientist working remotely with various analytical companies. I’m offering best quality and highest performance at a price we are both comfortable with. I can complet More

$30 USD in 2 days
(2 Reviews)
3.5
marfan080

Hi, I have read all your requirements and also checkted the attached file, I can add check against the drop down list so the user will only have option to select value from drop-down list. I have 6 years of experience More

$20 USD in 1 day
(22 Reviews)
3.6
EmiliaSimon

Hello, I have seen your requirements, and I am ready to help you make your macro run on a protected sheet. I am a Data Analyst experienced in VBA, and I can quickly and easily deliver the results you need. Please feel More

$20 USD in 1 day
(5 Reviews)
2.2
MamukaB

Good Day I checked your file. Protect sheet from some actions with password and then I can use drop-down menus as must used If I will paste or write different number that is in DDmenu giving error message as must be More

$10 USD in 2 days
(3 Reviews)
1.1
dmitryeremenko

Hello. Nice to see you. I saw the description of your project. As you know, I am a new freelancer. I am a freelancer with perfect abilities. Talk to me and you will know everything about me. I always guarantee my abili More

$20 USD in 1 day
(0 Reviews)
0.0
sakelarioleole

Hi. I am an individual software engineer has a solid experience in ✤ Classic ASp | Vb .Net ✤ C# | .NET 5 | .NET Core | MVC 5 | ✤ Web API | Microservices | Blazer | REST ✤ Entity-Framework |[login to view URL] ✤ Sql | No Sql ✤ Link More

$20 USD in 1 day
(0 Reviews)
0.0
kvaraxina

Hi. I am an individual software engineer has a solid experience in ✤ Classic ASp | Vb .Net ✤ C# | .NET 5 | .NET Core | MVC 5 | ✤ Web API | Microservices | Blazer | REST ✤ Entity-Framework |[login to view URL] ✤ Sql | No Sql ✤ Link More

$20 USD in 1 day
(0 Reviews)
0.0
Shablu4u

Hi, I have a deep understanding and experience in Excel Vba. ****************************************************************** I'm sure to complete this project with high quality on time. Looking forward to hear more More

$30 USD in 3 days
(0 Reviews)
0.0
CaebArizpe09

hola puedo ayudarte con el proyecto solo necesito que subas el archivo para poderlo analizar y ayudarte con ello

$20 USD in 3 days
(0 Reviews)
0.0
ojhabishnujsr

I'm confident that I can bring this type of success to this position. I am confident that I am a good fit for this position for several reasons, but most specifically because of my dedication to going above and beyond More

$20 USD in 7 days
(0 Reviews)
0.0
Rahu180119

I will do your project as soon as possible and I am expert in excel I will do your project I am expert in data mining

$20 USD in 7 days
(0 Reviews)
0.0
wijesundaranp

Hi, I can solve your project. Give me a chance. I have more than 25 years experience. If I receive this job I will do it on time.

$15 USD in 5 days
(0 Reviews)
0.0