toolbar
fernando,
Try using the file's workbook close event to delete and re-create the
toolbar button, assigning the macro with a full path. If the file's name
has changed, then the macro assignment would also change.
HTH,
Bernie
MS Excel MVP
wrote in message
...
I already have code to create toolbar (dont delete it when
workbook is closed), however I have to run it everytime
the filename is changed. Besides, users open the workbooks
by clicking on the toolbar button..
-----Mensaje original-----
fernando,
There is no automatic way. You need to have VBA code in
your workbook that
creates / deletes the toolbar buttons when the workbook
is opened / closed.
Post back if you want to use code to do this.
HTH,
Bernie
MS Excel MVP
"fernando" wrote in
message
...
Hello,
I have macros linked to toolbar buttons. When users
change
name for the file containing macro, the link breaks up.
Is
there a way to make this "link" again automatically?,
without making an add-in and with code?
Thanx
.
|