Run VBA Code on Protected Worksheet 

I am not a person who has been educated in VBA (but intend to). My users wanted a multi-select dropdown list in the Excel form I provided, which I was able to accomplish, but I had to protect the worksheet...and it would not work!!!! Your good instruction has made it possible for me to give them what they wanted...and for me to finally get a good night's sleep! Thank you, Thank you.

Why can't everyone make it as straight forward as you!? Thank you!!

Worked nicely for me; I had an input sheet and and a separate output sheet. I kept the command buttons on the input sheet, inserted your code lines you showed, and got the output sheet protected. Many thanks Dinesh!

Thank you Sir... This was the simpliest solution for me. I have zero knowledge in VBA and it worked like a charm first time I tried it unlike other solutions I had come across online.

Some one please give this man a cookie!! You just helped me so much ch thank you!!!!!

Thank you Sir ! You just helped me too much ! Be blessed 🙏 🤝 From Burkina Faso 🇧🇫

Thankyou so much!! in any sheet, For Any command button vba code, just adding activesheet. Unprotect and activesheet.protect worked perfect!!

Hi Sirji This is the first time I've used your help and it has worked easily Thanks thank you very much

Good morning Sir..your voice and method of explanation is owesome.

Thank you so much for this video Dinesh. This is exactly what I was looking for.

Thank you so much, exactly what I was looking for. Very helpful!

So many good projects 👍

This has been a huge help to me. Thank you for the video!!

Thank you very much, it was great help!

Thank you so much.... Exactly i m looking for...,

Very Nice Guidance !! Great one!!!

Highly valuable inputs

Thank you very much! Your video was xtremely helpfull

Worked like magic! Thanks a ton!

Thanks for the video sir..This thing was screwng me since 3 days

THANKS SIR REALLY USEFUL VIDEO

This is Amazing. Thank you so much..

You can also add the code in any sheet to call any other sheet. Like writing code for sheet2 : "sheet1.unprotect" & "sheet1.protect".

It doesnt work if you have mumltiple sheets connected to your macro. Ive a lot of calls on some modules and unpro and pro is not reliable. Still looking something to work.

Dear sir, Is there a way through VBA to prevent a particular cell from being changed by a user? this particular cell contains an auto increment invoice number (by vba function) and don't want users to change this to any other number.

Excellent! Thank you.

Hello Dinesh Thank you for sharing this.

This works sweet! thank you very much! :)

sir can I get coding for getting values of multiple workbooks in a single work sheet/form. Beacuse i have data in different work books

Thankyou Sirji

Thank you Sir

Why did you delete the button?

What's your background?

Hi Dinesh, I have not set any password for my sheet, i have just protected the sheet using Format cells option under Home tab in Office 2013, so how to write a script for that.

nice work sir

Good man, Dinesh!

Thanks 👍

What formula can I use: I have employee schedule: "Rosa" this person have a daily position where she will work. That work position is another sheet. / cell"A" Rosa / cell "B" 8am-5pm / cell "C" drop box asking what position she will be. Now by selection from de drop box X position. "Sheet 2" can take that information in put her name "Rosa" into the right position. Remember in sheet 2 there15 difference position I by clicking drop box dishwasher "Rosa" will be dishwater on sheet 2.

Thanks, it worked.

Sir I have a problem coding in Excel VBA, which needs your guidance. When executing a macro with the command button in Excel, an error occurs while copying and pasting the formula via VB code. I want the VB code to run and the previous line formula to be pasted into the next line and the formula to be hidden and protected without any errors. While the rest of the cells remain unprotected for data entry. Can you guide me in this regard?

Hello Dinesh,I have a VBA which runs automatically when the file is oppened. Now I need to password protect the whole file/workbook, which is easily done. Although the issue is that next time I open the protected file, I got a pop up window saying that my macros have been disabled and can not run them. Would you happen to have any workaround. So far I didnt find anything usable. Thank you, Joe

Hello Sir, I watched your video.Great video & with good presentation. Sir,I want your advice.I always like to learn a new thing like Excel,word access,VBA. (Still Learning) But i dont know how to use this knowledge in professional life. I want to become Trainer but most of recruiter want experience trainer.Well,i need your precious advice that what are other options? Sorry to ask you question like this but i would be grateful to you if you help me.

I want to do same process with sharad workbook. How to do?

Hello sir , I have a macro protected excel sheet, I want to see the formulas . How to remove the protection.

Sir, very good knowledge from I got this video.. but can I open password protected another workbook on my current sheet..

Good evening sir, I created an attendance report sheet with a column header called "student status" with a drop down box that includes "Dropped", "Completed" and "Continuing". On another sheet is the following month's attendance report, that I have added a command button to add any continuing students from the prior month. This saves my end users the time and trouble of copying and pasting the data onto the other sheet. It works beautifully, however, I needed to protect some of the cells, to keep instructors (end users) from accidentally deleting any formulas, I find that the command button does not work while in protection mode. Is there a special code that I can use for to allow the button command to work even in protection mode so that my end users can still click on the button to paste the "continued" students?

Hi sir, I am new to VBA, I tried searching a lot about if I could extract data from website which is supported on Mozilla Firefox into excel by macro . I could not find anything relevant. Also the specific site has a login. Please guide me in this. It will be really helpful. Thank you.

Hello Sir, I tried your code, it worked. However I am using pivot charts and in it after applying your code my slicers stopped functioning. Can you suggest a way in which the sheet remains protected after running the vba code but the slicer (time filter) associated with the pivot tablets keep on working

THANK YOU

Hi Sir, How should I protect the file after copy the data: Below are the scenarios, Where I have created a commandbutton to copy a data from sheet A to Sheet B; Hence I would like that after I clicking the commandbutton then the data is transfer to Sheet B then the data at Sheet B will lock for editing. Could Sir assist in this concern.?

Sorry for late reply. I am Bcom Graduate and working now in BPO.

Thanks

Sir, is there any way to protect my excel workbook reselling to other person by who got my excel workbook from me. Thank you in advance

Dear Sir, I want to apply protection to only one column and rest of the file must be editable.

Dear Sir, I need to make 3 users for a single excel file like "admin", "manager", "data entry" each has different permission if so how I can do that. Admin full access, Manager allowed to make few calculation, data entry is allowed to enter the data.I was trying to make use of User forms. Will you be kind enough to give me some light on this area. Thanks in advance.

Dear, is possible to entry the data by using user form in hided worksheet so no one can see the data ,only allow to enter the data

Your video is very useful..sir Is it possible to run macro in inactive protected sheet from active sheet..? Pls help..

HI thank you so much for your videos . I just would like to ask. I am currently using Excel 2016 on my macbook but the toolbar and the userform features do​ not appear. Toolbar had been greyed and there is no userform open on the insert option. I have a macbook air late 2015 on Sierra. Please help. thank you.

it is great help. thank you. it's work with me but my sheet has another codes where has some dropdown list ,whenever I change the answer from the list that protection never work. What do I need to do sir?

What if sheet 1 and sheet 2 are protect and you wanted to copy and paste special values from sheet 1 into sheet 2 . But both tabs were protect how would unprotect and protect both sheets in this scenario.

Hi Sir I am new to VBA, but is it possible to run vba code on the protected sheet data , when data is already linked to other protected sheet(s). for example in your video , if I assume that the data for sorting is linked to some other protected worksheet, then what would be the VBA code. THANKS...

Where is the button?

hi Mr Dinesh first i want to thank u for the video i was searching for , i already used it on macro buttons , but it didn't work on combobox made by developer and macro , so i need a code to make vba combobox work with a protect worksheet . and thank you again.

Sir how I run macro in structure protected workbook

how to run macro in shared workbook?

Hello Sir, I want to Run The VBA Code With a Protect Workbook..

This code use in workbook password protected

How to run VBA Code on Protected File

😂 you really confused your student and you haven’t solved his problem. Your student wanted to know how to have sort button with protected sheet without error and you explained here how to password protect a sheet in vba. Lol 😂 you solved the problem by removing his fancy button. Poor student!

Thank you sir