top of page
Power BI | Excel | Python | SQL
Search
![SUM Cells by Color in Excel with VBA](https://static.wixstatic.com/media/a3da57_9d21893131674efca60f57e25da58fd5~mv2.png/v1/fill/w_299,h_168,fp_0.50_0.50,q_95,enc_auto/a3da57_9d21893131674efca60f57e25da58fd5~mv2.webp)
Antriksh Sharma
Jul 5, 20211 min read
SUM Cells by Color in Excel with VBA
In this tutorial lets see how we can SUM cells in Excel with similar colors with the help of VBA. The dataset we are going to use: Now go...
1500
![Option Private Module in VBA - Prevent users from accessing sub-routine or functions.](https://static.wixstatic.com/media/a3da57_0a99b7f2a33f45ad851a86febaf1d7ad~mv2.png/v1/fill/w_299,h_168,fp_0.50_0.50,q_95,enc_auto/a3da57_0a99b7f2a33f45ad851a86febaf1d7ad~mv2.webp)
Antriksh Sharma
May 26, 20211 min read
Option Private Module in VBA - Prevent users from accessing sub-routine or functions.
VBA allows you to create sub-routines or functions that can be hidden from the end user using only Excel interface, but sometimes that...
6263
bottom of page