I tried your code and while it updates the source file it does not capture the cell references leaving the code useless in the specified case. [workbook.xls]Graphs Chart 3) and the formula does not change the second occurrence of the workbook name in brackets. Source Full Name is blank Can you it in yours and let us know what the msgbox shows please?
By using forms and the many controls and objects that you can add to them, you can significantly enhance data entry on your worksheets and improve the way your worksheets are displayed.
Text = "My New Caption" Regards Veena" id="ctl00_m_m_i_ctl00_gr_ctl01_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="3618783" / Depending on which button you're talking about, will dictate how you change its caption. If you created the button via the Forms toolbar then you need to use Veena's solution Active Sheet.
Text = "My New Caption" If however, you created it via the Visual Basic toolbar then you need to use a solution similar to Skip's: active Sheet.commandbutton1.caption="My New Caption" HTH Martin" id="ctl00_m_m_i_ctl00_gr_ctl05_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="3619640" / Hi, Depending on which button you're talking about, will dictate how you change its caption.
When finished, the routine restores the shape to its original size.
This routine activates the worksheet we renamed “Data”, and passes our “Logo” shape to two routines. Before returning, the Grow routine makes sure the shape is exactly as we found it. It freezes the screen, remembers the shape’s original dimensions, then alters the shapes size in a loop that simulates the shape spinning around its Y axis.