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.
@hollysmith929
2 жыл бұрын
Why can't everyone make it as straight forward as you!? Thank you!!
@Exceltrainingvideos
2 жыл бұрын
Wow! Please share my KZitem channel on Excel with your friends too.
@cstjero
6 жыл бұрын
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!
@jpmaina
7 ай бұрын
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.
@franckdonaldnikiema7579
3 жыл бұрын
Thank you Sir ! You just helped me too much ! Be blessed 🙏 🤝 From Burkina Faso 🇧🇫
@Exceltrainingvideos
3 жыл бұрын
Glad to hear that. Please share with your friends too.
@tajsay
4 жыл бұрын
Thank you so much for this video Dinesh. This is exactly what I was looking for.
@Exceltrainingvideos
4 жыл бұрын
You are welcome. Please share with others and spread the knowledge.
@tanushree2475
5 жыл бұрын
Thankyou so much!! in any sheet, For Any command button vba code, just adding activesheet. Unprotect and activesheet.protect worked perfect!!
@Exceltrainingvideos
4 жыл бұрын
You are welcome. Please share with your mates also on social media.
@ronaldolima-qe1qf
6 жыл бұрын
Some one please give this man a cookie!! You just helped me so much ch thank you!!!!!
@hrishikeshchaudhari2456
5 жыл бұрын
Hi Sirji This is the first time I've used your help and it has worked easily Thanks thank you very much
@Exceltrainingvideos
4 жыл бұрын
You are welcome. Share with your friends to spread the knowledge.
@pvnr5930
10 жыл бұрын
Good morning Sir..your voice and method of explanation is owesome.
@forex7769
2 жыл бұрын
So many good projects 👍
@Exceltrainingvideos
2 жыл бұрын
Thanks!
@bigdan8936
7 жыл бұрын
This has been a huge help to me. Thank you for the video!!
@congeeW
3 жыл бұрын
Thank you so much, exactly what I was looking for. Very helpful!
@Exceltrainingvideos
3 жыл бұрын
Great to hear!
@s.r5264
3 жыл бұрын
Thank you so much.... Exactly i m looking for...,
@Exceltrainingvideos
3 жыл бұрын
Most welcome 😊 Please share my Excel VBA KZitem channel with your friends too. Thanks.
@javedahmed8343
2 жыл бұрын
Highly valuable inputs
@Exceltrainingvideos
2 жыл бұрын
Welcome!
@sudhakargunjal4834
7 жыл бұрын
Very Nice Guidance !! Great one!!!
@Test_yourknowledge
4 жыл бұрын
THANKS SIR REALLY USEFUL VIDEO
@Exceltrainingvideos
4 жыл бұрын
So nice of you! Please share this VBA tutorial in Excel with your friends also on social media like Facebook, etc.
@Test_yourknowledge
4 жыл бұрын
@@Exceltrainingvideos ok sir
@chahnakaria4519
5 жыл бұрын
Thank you very much, it was great help!
@Exceltrainingvideos
4 жыл бұрын
Please share with your friends and on social media. You can view more videos in Hindi and English at www.exceltrainingvideos.com/
@kosigadesiga3152
5 жыл бұрын
Worked like magic! Thanks a ton!
@Exceltrainingvideos
4 жыл бұрын
You are welcome. Share with your friends also on social media to spread the knowledge.
@dhirajp4677
4 жыл бұрын
Thanks for the video sir..This thing was screwng me since 3 days
@Exceltrainingvideos
4 жыл бұрын
Glad I could help. Please share my VBA tutorials with all your friends also on social media.
@AmitGupta0985
4 жыл бұрын
Thankyou Sirji
@Exceltrainingvideos
4 жыл бұрын
Welcome! Please share the VBA tutorials with your friends on social media.
@kath_erinelara
4 жыл бұрын
Thank you very much! Your video was xtremely helpfull
@Exceltrainingvideos
4 жыл бұрын
You are welcome. Please share with your friends also.
@mr.write1433
8 ай бұрын
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.
@sushantbehera2485
2 жыл бұрын
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
@jameswilkinson8069
7 жыл бұрын
Excellent! Thank you.
@milkbattle
7 жыл бұрын
Hello Dinesh Thank you for sharing this.
@premchauhan9109
4 жыл бұрын
Thank you Sir
@Exceltrainingvideos
4 жыл бұрын
Welcome! Please share the Excel VBA tutorials with your friends.
@tanushree2475
5 жыл бұрын
You can also add the code in any sheet to call any other sheet. Like writing code for sheet2 : "sheet1.unprotect" & "sheet1.protect".
@Exceltrainingvideos
4 жыл бұрын
Can you share your code?
@Exceltrainingvideos
10 жыл бұрын
What's your background?
@mosleyuddinsujon6898
Жыл бұрын
Thanks 👍
@adityabhat3108
3 жыл бұрын
This is Amazing. Thank you so much..
@Exceltrainingvideos
3 жыл бұрын
Glad you like it!
@AhesanAli
9 жыл бұрын
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.
@camilovinatea7747
4 жыл бұрын
This works sweet! thank you very much! :)
@Exceltrainingvideos
4 жыл бұрын
Don't forget to share with your friends! Thanks.
@Joboy199204
9 жыл бұрын
Good man, Dinesh!
@MrHorzel
6 жыл бұрын
Why did you delete the button?
@saifsudais
3 жыл бұрын
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?
@Exceltrainingvideos
3 жыл бұрын
This link will guide: kzitem.info/news/bejne/xmaay5qIkYqhl6A
@HenriPadilla
11 жыл бұрын
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.
@SRC30
7 жыл бұрын
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.
@SpaceWalkTraveller
8 жыл бұрын
Thanks, it worked.
@josephmasaga8285
9 жыл бұрын
nice work sir
@yogeshshelar9155
4 жыл бұрын
Hello sir , I have a macro protected excel sheet, I want to see the formulas . How to remove the protection.
@Exceltrainingvideos
4 жыл бұрын
Unprotect the worksheet using the password. This VBA tutorial will help: www.exceltrainingvideos.com/run-vba-code-macro-on-protected-sheet/ Or search www.exceltrainingvideos.com
@ankitchand3275
6 жыл бұрын
Sir, very good knowledge from I got this video.. but can I open password protected another workbook on my current sheet..
@LoudFindings
5 жыл бұрын
I want to do same process with sharad workbook. How to do?
@TheFebinedwards
4 жыл бұрын
Thanks
@Exceltrainingvideos
4 жыл бұрын
Welcome! Sharing is caring!
@joztik
9 жыл бұрын
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
@venkatesh2285
3 жыл бұрын
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
@Exceltrainingvideos
3 жыл бұрын
You can purchase special software at a price.
@prathameshmhetre5597
6 жыл бұрын
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.
@magdyibrahim126
9 жыл бұрын
THANK YOU
@mahhongyew9524
4 жыл бұрын
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.?
@Exceltrainingvideos
4 жыл бұрын
The link to this VBA lesson will guide: www.exceltrainingvideos.com/tag/automatically-lock-worksheet-cells-after-data-entry-using-vba/
@mahhongyew9524
4 жыл бұрын
Hi Sir, I tried; Nonetheless, it shows compiled errors. Could Sir walk me through again?
@rocky20717
10 жыл бұрын
Sorry for late reply. I am Bcom Graduate and working now in BPO.
@souringoswami6047
4 жыл бұрын
Your video is very useful..sir Is it possible to run macro in inactive protected sheet from active sheet..? Pls help..
@Exceltrainingvideos
4 жыл бұрын
Can you elaborate a bit more?
@souringoswami6047
4 жыл бұрын
@@Exceltrainingvideos Sir.. Let suppose i am having 4 sheets and in first sheet i have user form and connected with rest three sheets through macro. Now i want to protect 2nd ,3rd,4th sheet. And also want can access these three sheet from user from , means from first sheet. Tq
@rocky20717
10 жыл бұрын
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.
@keithandpilarschumaker5343
6 жыл бұрын
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?
@Exceltrainingvideos
6 жыл бұрын
This link might help: www.exceltrainingvideos.com/allow-data-entry-specific-worksheet-cells-in-excel/ Or search www.exceltrainingvideos.com
@paraskatoch271
4 жыл бұрын
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
@Exceltrainingvideos
4 жыл бұрын
Try again
@kandila8
6 жыл бұрын
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.
@Exceltrainingvideos
6 жыл бұрын
www.rondebruin.nl/
@kandila8
6 жыл бұрын
I seems some features are not enabled when in Mac Office 2016 =0(
@restfun103
7 жыл бұрын
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?
@Exceltrainingvideos
7 жыл бұрын
Search www.exceltrainingvideos.com and work harder!
@mathewsjacob5548
9 жыл бұрын
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.
@Exceltrainingvideos
9 жыл бұрын
Mathews Jacob The links below may provide a direction:@protect-specific-excel-worksheets-using-vba/@protect-worksheet-using-excel-vba/@how-to-hide-excel-vba-code-using-password/@compare-userform-data-with-worksheet-data/
@bhupendrabissa2883
4 жыл бұрын
Dear Sir, I want to apply protection to only one column and rest of the file must be editable.
@Exceltrainingvideos
4 жыл бұрын
These Excel learning tutorials will help: www.exceltrainingvideos.com/protect-worksheet-using-excel-vba/ www.exceltrainingvideos.com/allow-editing-in-protected-worksheet-with-vba/ www.exceltrainingvideos.com/automatically-password-protect-excel-worksheet-and-lock-cells-after-data-entry-using-vba/ www.exceltrainingvideos.com/protect-worksheet/ www.exceltrainingvideos.com/allow-data-entry-specific-worksheet-cells-in-excel/
@risvananoushad3285
7 жыл бұрын
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
@Exceltrainingvideos
7 жыл бұрын
Try it out and share it!
@brianconroy6636
8 жыл бұрын
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.
@Exceltrainingvideos
8 жыл бұрын
Unprotect both the sheets as you unprotect one! Also, vice-versa.
@brianconroy6636
8 жыл бұрын
thank you I figured it out the coding is slightly different tho, Instead of Activesheet. you use Sheet1. This is where I was having difficulties hen using the code in this video.
@casper3842
5 жыл бұрын
Where is the button?
@Exceltrainingvideos
5 жыл бұрын
This link will help: www.exceltrainingvideos.com/how-to-assign-recorded-macro-to-command-button-in-excel/
@ManojThakur-fd7yv
6 жыл бұрын
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...
@Exceltrainingvideos
6 жыл бұрын
You'll have to 'unprotect' the sheets.
@ManojThakur-fd7yv
6 жыл бұрын
Thanks sir Can u please share the vba code to unprotect any sheet in workbook from the active sheet
Hello Sir, I want to Run The VBA Code With a Protect Workbook..
@Exceltrainingvideos
9 жыл бұрын
Sanat Pattnaik www.exceltrainingvideos.com/run-vba-code-macro-on-protected-sheet/ kzitem.info/news/bejne/2Kxnp5uQi2t4ZZg
@flowrittarose
7 жыл бұрын
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.
@Exceltrainingvideos
7 жыл бұрын
What VBA code have you written?
@flowrittarose
7 жыл бұрын
this is the code Private Sub ComboBox1_DropButtonClick() ComboBox1.ListFillRange = "newaccounts" Me.ComboBox1.DropDown ActiveSheet.Unprotect Password:="asdf" End Sub Private Sub ComboBox1_LostFocus() ActiveSheet.Protect Password:="asdf" End Sub
@flowrittarose
7 жыл бұрын
this is the code Private Sub ComboBox1_DropButtonClick() ComboBox1.ListFillRange = "newaccounts" Me.ComboBox1.DropDown ActiveSheet.Unprotect Password:="asdf" End Sub Private Sub ComboBox1_LostFocus() ActiveSheet.Protect Password:="asdf" End Sub
@Exceltrainingvideos
7 жыл бұрын
Works fine. The combo-box is an ActiveX control on your worksheet.
@ankitchand3275
6 жыл бұрын
This code use in workbook password protected
@leech7172
5 жыл бұрын
How to run VBA Code on Protected File
@Exceltrainingvideos
5 жыл бұрын
First unprotect the file, do your actions and then protect it again before closing as shown in the video. For more solutions search www.exceltrainingvideos.com/
@elmnycollin1508
5 жыл бұрын
😂 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!
Пікірлер: 125