Macro button that others can see

  • Thread starter Thread starter Newbee
  • Start date Start date
N

Newbee

I have a macro custom button on my spreadsheet that I use to run several
macros. However If I forward that spreadsheet to another user to use they
don't see my macro button. Is there something else I can use so that they
will see and use the macro button?
 
If you have a button on your spreadsheet (ie, it is a button you
created with the forms toolbar) then they will see it when they open
the sheet. However, if you have created a TOOLBAR button, then they
will not see that as it resides only on your computer.
The other question is where are you storing the macro? If it is the
document, then they will be able to use the macro, but if it is in
your Personal Macro Workbook then it, likewise, is stored on your
computer only (but could be migrated).
 
Thank you, I have created a Toolbar button. I didn't know you could create
a button with the forms toolbar. I will look this up. The macro is in the
worksheet but I would always have to tell them how to use it. Thank you!
 
Back
Top