by Why don't you write macros to rewrite the button's text ? Why do you needQuote:> Can anyone help me with a couple of problems I'm having.
> Problem 1.
> I want the name on a macro 'button' to get it's text from another
> location.
to take the button's text from a cell instead of rewritting it straight
using a macro ?
There is only one solution for this. Before making the changes you wantQuote:> Problem 2.
> I have a ton of macros written and now want to reshape the spreadsheet
> they reference. It's going to be *y painful if I don't find a
> resolution.
to your worksheet, try to give names to the ranges you use in macros.
Then change your macros, replacing all the range references by their range
names. Save the file and then make the changes to your worksheet. The
range names will be updated automaticaly as you make changes in the
worksheet.
This is the only option you have. If you have any questions please
feel free to contact me by email. Hope it helped.
> Many thanks in advance.......
> --
> Paul Hodges
Gordon Daniel > --
> Paul Hodges