Apr 30, 2019 | Excel, VBA
Merge bunch CSV files into one single Excel file manually requires a lot of time and efforts, and on top of that, it’s a painful task. What if you can automate the process with just a single macro?In this tutorial, I will teach you how to write a VBA script to...
Apr 29, 2019 | Excel, VBA
Quiet often when you collaborate with a team member or group of people on a Excel spreadsheet, when the most commonly thing is people will apply strikethrough to the items or texts they want to remove from the file. Not sure why in Excel, there is no function to...
Apr 24, 2019 | Excel, VBA
Protecting a single worksheet is pretty easy, you simply hover your mouse, right click, and select Protect Sheet. But what happens if you are working on a Excel workbook that has like 50 worksheets and you want to password protect just certain worksheets?In this...
Apr 19, 2019 | Excel, VBA
When you work with Excel files that contain macros, ActiveX Control, userforms, or connect to an external data source, sometimes, you will get those annoying Privacy Warning message “Be careful! Parts of your document may include personal information that...
Apr 15, 2019 | Excel, VBA
An audit trail is a record or log captures a change. For example, when you change a product price from $10 to $15, the change in the $5 difference is a trail. Audit trail is commonly used in accounting, finance, retail, and other industries. Unfortunately in Excel,...
