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?
|