Running totals simply means the cumulative sum of a sequence of values. The application of calculating running total is quite significant for business purposes ...
When you have a larger dataset and you want to export an image from the particular cell values, a linked picture might be the best option. As the linked ...
Placing parentheses for negative numbers is a common exercise popularly used by accountants to increase readability. Nowadays, it is also displayed in red ...
While creating or modifying a UserForm, you may need to add or create images from the worksheet. In this instructive session, I’ll demonstrate 3 methods to add ...
Frequently, you may need to find a particular data, formatting, or even cell references and then replace it with something new. Find and Replace is one of the ...
The VBA Dynamic Range provides you the opportunity to use the same code for newly added or removed data while working with a larger dataset. However, it will ...
Often you may need to VLOOKUP dealing with the date. If you want to return a certain value or values for the date range instead of VLOOKUP by date, you’re here ...
Pivot Table, one of the powerful features in Excel, analyzes the larger dataset efficiently. But probably you have faced the problem of date formatting in the ...
If you have a larger dataset and you need to apply filters in columns. More importantly, you might require to count only unique values except for the duplicate ...
Once you input any data for example a number, it will be stored typically as a number. More importantly, if the number of digits is greater than 15, your input ...
Sometimes we need to combine multiple cells into one keeping with the line break. Undoubtedly, Excel provides some quickest features to do that. In this ...
Most likely you see a checkbox that is mainly used for selecting or deselecting any option. Though the process of adding a checkbox in Excel is quite easy, you ...
Basically, you may need to lock multiple cells for two reasons. One is to lock cells for protecting them from further edits or changes whereas the other reason ...
While working in Excel, you might hear the absolute cell reference. This type of cell reference remains unchanged if you copy, move or even use it in an array. ...
Perhaps you may have a larger dataset with numerous blank cells. Using a popular highlighting tool i.e. Conditional Formatting, you are easily able to ...
Md. Abdul Kader
Hello EAC,
Thanks for your question. Most likely, you need to put a not equal sign (<>) inside the If…Then statement of your second code. So, the corrected second code will be as follows-
However, your used three codes are quite messy. I would like to suggest that you can use the following code to lock a specific cell range in all worksheets of your Excel file.
Again, try this code to unlock the specific cell range in all worksheets.
I hope these will work! Moreover, you can follow lock and unlock cells using VBA to explore more efficient methods.
Hello Michael,
Please specify your problem in detail or send the excel file via [email protected] email address.
Dear Deka,
It’s nice to hear from you with such wonderful appreciation. I myself always try to represent Excel applications in a more user-friendly way. And we, the ExcelDemy team, are working as a one-stop Excel solution provider.
Thanks, and take care of yourself. Goodbye!
Md. Abdul Kader
Editor, ExcelDemy.