You will get Colorful MS Project Tasks in Gantt Chart using VBA Macros Button
Top Rated
You will get Colorful MS Project Tasks in Gantt Chart using VBA Macros Button
Top Rated
Project details
Would you like your MS Project Gantt Chart Activities to look colorful and categorized based on levels of Summary Tasks? or are you a Planning Engineer who's accustomed to Primavera P6 color scheme of WBS?
Then I have Great News for you, you can make tasks or activities in MS Project colorful with one click of a button to look just like in Primavera P6.
Giving you Summary Tasks or WBS levels a color scheme, makes the schedule presentable and easy to understand. In just a glance you can understand which tasks belong to which category and which two WBS or Summary Tasks are of the same level. Your Activities or tasks would look organized and professional.
So, what are you waiting for? Get rid of MS Project's default black and white, plain and boring interface. and ride your way to the beauty of colors.
I'd provide you a Macros and a guide to how you can add a button above to run it. If you can join on Zoom, I'd do it for you on your Laptop using remote feature of Zoom.
Plus you can also ask to change these colors to your preferences, please message me your colors and I'd change it for you.
(You're free to use it for personal use, but you can not claim this VBA code to be yours)
Then I have Great News for you, you can make tasks or activities in MS Project colorful with one click of a button to look just like in Primavera P6.
Giving you Summary Tasks or WBS levels a color scheme, makes the schedule presentable and easy to understand. In just a glance you can understand which tasks belong to which category and which two WBS or Summary Tasks are of the same level. Your Activities or tasks would look organized and professional.
So, what are you waiting for? Get rid of MS Project's default black and white, plain and boring interface. and ride your way to the beauty of colors.
I'd provide you a Macros and a guide to how you can add a button above to run it. If you can join on Zoom, I'd do it for you on your Laptop using remote feature of Zoom.
Plus you can also ask to change these colors to your preferences, please message me your colors and I'd change it for you.
(You're free to use it for personal use, but you can not claim this VBA code to be yours)
Target Country
Worldwide, United States, United KingdomWhat's included $50
These options are included with the project scope.
$50
- Delivery Time 1 day
- Number of Projects 1
Optional add-ons
You can add these on the next page.
Custom Colors
+$5Frequently asked questions
11 reviews
(11)
(0)
(0)
(0)
(0)
This project doesn't have any reviews.
AP
Alanna P.
Feb 24, 2025
Merge Address Files Muddassar
SG
Stephanie G.
Jan 24, 2025
2025 Action Group Project
Muddassar was wonderful to work with. He was extremely professional and quite responsive. Even when I panicked with questions in the middle of the night, upon being online he scheduled a zoom call.
LH
Leila H.
Sep 25, 2024
Expert Google Appscript developer
Muddassar did an excellent job with Google Apps Script project. He also provided valuable suggestions to improve the project.
LS
Lanny S.
Sep 22, 2024
further changes to Google sheet chart
LH
Leila H.
Sep 18, 2024
Apps Script and VBA Job
Muddassar delivered exceptional results with both VBA and Google Apps Script. His deep technical expertise was evident in how efficiently he automated a complex task. He quickly grasped the requirements, provided innovative solutions, and exceeded expectations with his professionalism and attention to detail. Highly recommended for any project requiring advanced coding skills.
About Muddassar
Google Sheets / Excel Expert | Planning Engineer
97%
Job Success
Hafizabad, Pakistan - 7:17 am local time
As a civil planning engineer with hands-on experience in Primavera P6, MS Project and Google Sheets, I bridge the gap between raw data and robust project schedules. I use custom Excel and Google Sheets templates to prepare import-export files for Primavera P6, ensuring seamless integration of baseline, progress and cost-loaded schedules.
My services include
– Designing Google Sheets templates that export directly to Primavera P6 activity and resource layouts
– Building dynamic Gantt charts in Google Sheets to track real-time progress, float analysis and slippage
– Automating monthly lookahead plans, progress updates and S-curve reports with advanced formulas and pivot tables
– Writing Google Apps Script solutions for procurement and finance management systems, with role-based access, contract tracking and payment dashboards
– Developing email automation sidebars to send progress reports, cash-flow statements or procurement summaries on schedule
– Integrating ChatGPT AI API into Google Sheets to generate lists of activities, assign resources and estimate durations based on project scope
Recent project highlights
– Ministry of Finance, Somalia: created a procurement tasks tracker in Google Sheets, complete with secure access controls, interactive dashboards and automated email reminders
– New Zealand infrastructure proposals: built integrated master schedules in P6, exported data to Tableau and automated monthly progress updates in Google Sheets
– Water supply projects in Sialkot and Chaman: developed cost-loaded schedules with resource histograms, cash-flow forecasts and recovery plans for delayed works
– M-3 Industrial City, Faisalabad: planned multiple infrastructure lots, performed delay analysis and optimized resource allocation with custom histograms and cost reports
With over two years as a Top Rated Plus Upwork freelancer specializing in planning and schedule automation, I combine civil engineering know-how with spreadsheet programming to save time, reduce errors and deliver clear insights for stakeholders. Whether you need a complete Primavera P6 import template, a live project dashboard or a procurement management system in Google Sheets, I tailor solutions to your needs.
Let’s discuss how I can streamline your project planning and reporting workflows so you can focus on keeping work on schedule and on budget.
Steps for completing your project
After purchasing the project, send requirements so Muddassar can start the project.
Delivery time starts when Muddassar receives requirements from you.
Muddassar works on your project following the steps below.
Revisions may occur after the delivery date.
Customize or set your Colors
Changing or setting the colors for Summary Task Levels.