Macro button that others can see
 

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?

Macro button that others can see
 

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).

On May 28, 11:39 am, Newbee wrote:
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?

Macro button that others can see
 

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!

"Reitanos" wrote:

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).

On May 28, 11:39 am, Newbee wrote:
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?