I have a workbook with about 45 worksheets, each of which have 2
charts. When the workbook is opened I get a 4 character code from th
user via an InputBox. I'd like to take this code and prefix ever
chart title in the workbook with it.

Could someone post an example of the VBA code that I'd use t
dynamically loop through every worksheet/chart and append this to th
existing chart titles?

Thanks a lot. I'm familiar with VB but not familiar enough with Exce
objects to get this done in time.

BackPaddle

--
Message posted from http://www.ExcelForum.com