Thank you for your help, I updated the macro as suggested and it works fine now. I was able to resize the Activity name field by in-hiding the Gant sheet and adjusting the column width.
thank you for your help.
Another question related to the Gantt chart, is it possible to expand the width of the Activity Name and reduce the width of the Calendar portion of the chart?
Solved by un-protecting the sheet and resizing the Gantt chart, when I re-protect the sheet is there anything I need check on the leave un-protected list?