วีดีโอ

My pleasure. Thanks for watching. Wish you a wonderful day.

Hello! Whether the last row requires contact information or email depends on how the range is defined. If you need those fields to be mandatory, make sure to include them in your range. Otherwise, you can leave them out. Thanks for your comment, and have a wonderful day!

Hello. Recent updates to MS Office prevent users from removing passwords by changing the file format, especially if you are using MS Office 365. You may consider the new method shown here: th-cam.com/video/z9PeiAz33r0/w-d-xo.html. I hope it helps you. Thanks for watching, and have a wonderful day!

My pleasure. Thanks for watching. Wish you a wonderful day.

Hi! If you want to apply this trick to all your workbooks, you might find this method helpful: th-cam.com/video/A8bpF3RhF-U/w-d-xo.html. I hope you find it useful. Thanks for watching, and have a wonderful day!

You’re most welcome, boss 🤝🤝🤝

My pleasure. Thanks for watching. Wish you a wonderful day.

Thanks! It is my pleasure to share with you. Thanks for watching. Wish you a wonderful day.

Could you please provide your email address so I can send the file to you? If you're concerned about privacy, you can also email me directly at ahsing.math.excel@gmail.com, and I'll respond there.

My pleasure. I'm glad it helps you. Thanks for watching. Wish you a wonderful day.

My pleasure. Thanks for watching and have a nice day.

@@ahsing_excel_VBA what if you wished to fit A B C into the estimated profits how so that we see the area of cover based on the estimated profits

Customization of the code is necessary. This tutorial only demonstrates how to extract a password under the assumption that it contains only two lowercase letters. Additionally, changing the file path is another crucial step. If you were to copy the code verbatim without customization as instructed, the consequences would be as you described. Thanks for watching and have a nice day.

@@ahsing_excel_VBA I did do all the changes for 11 letters and the path. and got the message I give above

Hello, it may be because the file is in the drive where autosave is enabled. You may try disabling it to see if the issue is resolved. Thanks for watching. Wish you a wonderful day.

@@ahsing_excel_VBA Thank you! The problem was elsewhere. I had a line in my code that promped saving at the beggining. :D Anyway, thank you for your fast reply, you are doing a great job! Please continue. :)

My pleasure 😊

Thanks! I'm glad you like it 🙏 Thanks for watching. Wish you a wonderful day.

Thanks! Thanks for watching. Wish you a wonderful day.

can u sand my fille

Hi. You might want to try a different hex editor. Also, it's important to ensure that the folder is created in the right location before changing its file format. Thanks for watching and have a nice day.

🤔 I didn't help anyone remove the password to avoid getting involved in any unauthorized act. Sorry for that.

I'm glad you like it. Thanks for watching. Wish you a wonderful day 😀

Hi. This is an add-in calendar where the default setting sends the selected date to the active cell. You may consider changing the default setting if applicable; otherwise, a customized macro is needed. Thanks for watching. Wish you a wonderful day.

Hi. Select the required region and navigate to the 'Home' tab. Look for 'Conditional Formatting' and then 'Clear Rules,' either only for the selected region or the entire sheet. This will not highlight the cells even if they are selected. Hope this helps. Thanks for watching and have a wonderful day.

Glad it was helpful! Thanks for watching. Wishing you a wonderful day.

Thanks! Thank you for your suggestions. The reason I didn't indent is because it would increase the length of the code and might cause it to extend beyond my recording region. As you may have noticed, I use a larger font size and have enlarged the VBA script editor to enhance readability. Most of the time, I assume my audience has their own customizations, so I use multiple lines for 'If' statements. This allows them to add conditions as needed. Thanks for watching. Wishing you a wonderful day.

@@ahsing_excel_VBA thank you sir

Hello. 🤔 Since this is specifically for the calendar, which allows users to select and insert a date instead of typing it manually, I expect users to select a date before proceeding to the next task. If you want to run multiple macros at the same time, I usually open the workbooks as new instances of Excel so that they can run simultaneously. Not sure if this is what you were looking for. Thanks for watching. Wishing you a wonderful day.

My pleasure. Glad it helped. Thanks for watching. Wishing you a wonderful day.

Thanks! Thanks for watching. Wishing you a wonderful day.

Hi, you can add a line to define the variable first.

I tried to add as Dim WS as Worksheet Is it correct?

@@ahsing_excel_VBA What line i need to add as variable, Can you provide me the line , It will help me

yup. It is correct.

Did you notice a new worksheet was added? If so, delete the new worksheet and run it again. It should be fine then.

Yes every time new worksheet is getting created as blank

Hi. Thanks! If you are using the 'SelectionChange' event, copy the code and paste it into all necessary sheets in the VBA editor. Also, ensure that there is a list box on each spreadsheet. Thanks for watching and have a nice day.

​@@ahsing_excel_VBA thanks for your reply. is there a way just only create one List objects, then apply to other sheets. Instead creating list objects on each sheets. Thanks

Yes, there is. Instead of using controls, you may consider using a UserForm. Then call the UserForm whenever a cell within the desired ranges is selected.

Also you can Create an Add In from that Then it will be available All your workbook or worksheet But you have to knowledge of the Class Modules

Thanks! Thanks for watching. Wishing you a wonderful day.

really is

😅 Maybe one day Excel will introduce a new chart type that allows us to construct filled shape charts directly. Thanks for watching. Wishing you a wonderful day.

Hi. You have to test it one by one, trying two characters and then three, and so on. However, if you used a long and complicated password, it may take days to retrieve it. Therefore, it's very important to provide a pattern to Excel and narrow down the range of possible characters in use. I wish you success in getting back your password as soon as possible. Thanks for watching and wishing you a wonderful day.

My pleasure. Thanks for watching. Wishing you a wonderful day.

Hi. Is this what you are looking for: th-cam.com/users/shorts50I9cTBYGac?feature=share? I hope it is useful. Thanks for watching, and have a nice day.

Hi there! The functions for upper case, lower case, and proper case in VBA are UCase(String), LCase(String), and StrConv(String, vbProperCase) respectively. For example, if you want to capitalize all words in TextBox1 of UserForm1, simply double-click on the textbox and type: Me.TextBox1 = UCase(Me.TextBox1). Hope this explanation helps. Thanks for watching, and have a nice day.

Thank you sir

My pleasure 😊

@@ahsing_excel_VBA YOU ARE A LIFE SAVER I NEEDED EXCATLY THIS FOR A PROJECT !!!!!!!<3

Hi. Yes, use the checkbox under ActiveX Controls. Then, while the 'Design Mode' is on, double-click on the checkbox and use an 'If' statement to set the condition to check the three checkboxes. Hope this helps. Thanks for watching, and have a nice day.

Too bad. This is the limitation of Shorts where I can't explain it in detail. My original script is more than a minute long. However, because this is a Short, I must trim the portions that I think are unnecessary. The analytics showed that 94.5% of viewers could follow. Therefore, I didn't make a video on this topic. Maybe you can try following the texts/instructions that I typed on the video. I'm sorry that I wasted your one minute. By the way, I wish you a nice day.

Thanks for watching and have a nice day.

Hi. In that case, you might need a List Box. Thanks for watching and have a nice day.

@@ahsing_excel_VBA Can you make a video of it. Or, if you've already made one, can you post the link.

Hi. Here it is: th-cam.com/video/npcOckscFgc/w-d-xo.html. I hope it's not too late for you.

Hi. I guess you have forgotten to call the module in each UserForm, just like at 1:07. Hope this resolves your issue. Thanks for watching and have a nice day.

Hi. For older versions of Excel, I believe it can be done since I've done it before with version 2010. If you're asking about Office 365, I don't think it's possible based on my experience, as it will corrupt the file.

I did all steps but it did not open the file ,and was saying file may be corrupted.

@@angel-hb8wl In that case, you might want to try a different hex editor. Also, it's important to ensure that the folder is created in the right location before changing its file format. Have a nice day.

Hi. You can create a variable, let's say 'm', with an initial value of 1, and then use 'm = m + 1' to update it from 1 to 3. Next, use an 'if' statement to set it as 'Yes', 'No', or 'Incomplete'. Finally, reset 'm' to 1 when it reaches 3. Hope this helps. Thanks for watching and have a nice day.

Thanks! Thanks for watching and have a nice day.

My pleasure. Thanks for watching and have a nice day.

Hi. Sorry to say that I typically don't share macro codes that are short or require customization, preferring to demonstrate step-by-step instructions instead. Thanks for watching and have a nice day.

Oh it's really okay, after watching many videos I landed up watching your video and it was really helpful thanks for sharing this video.

Hello! When dealing with milliseconds, utilizing the 'Sleep' function is essential. You can find a demonstration video at th-cam.com/video/Phh9zyCIOEA/w-d-xo.html. Keep in mind that the 'Sleep' function's performance may vary across different computers due to differences in their systems. I hope this information is helpful. Thank you for watching, and have a wonderful day!

@@ahsing_excel_VBA Thanks. I will take a look into it. Regards

My pleasure and thanks ❤️❤️ Thanks for watching and have a nice day.

Hello there. Thanks! :) Can insert the code before 'End Sub'. Hope this helps. Thanks for watching and have a nice day.

Hi. Yes, indeed! Fortunately, we can accomplish this task quite easily with VBA. Simply click on the related video link, and you'll discover the solution. Thanks for watching and have a nice day.

Thanks! Thanks for watching and have a nice day.