Custom Buttons

T

thewizz

I have created several custom buttons and a toolbar that I have attached to
an Excel Document. The Buttons run several Macros. The problem I am having
is:

After saving and openning the file on a different computer, the toolbar
opens but the buttons are gone!?!?

Any ideas how I can fix this?

Thank you!
 
D

db ´¯`·.. >

if i recall, you can try
the following method:

try going into visual
basic, which is an option
provided under tools, macro.

inside the vb environment
you will likely see your
macros and their codlings.

you should also see on
the left hand side where
you can expand the worksheets.

basically, the macros should
be moved from their generalized
location into the
specific worksheet that
they were designed for.

then use the "compile"
feature to ensure everything
is compiled and functional,
save.

afterwards make sure your
buttons have the macros
assigned and working again.

what should happen is
that the vb code for your
macros will be attached to
that specific worksheet.
--

db ·´¯`·.¸. said:
<)))º>·´¯`·.¸. , . .·´¯`·.. ><)))º>`·.¸¸.·´¯`·.¸.·´¯`·...¸><)))º>


..
 
Top