| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Macro to sort without clicking on macro button | Excel Discussion (Misc queries) | |||
| use macro button to run macro in protected sheet | Excel Discussion (Misc queries) | |||
| F9 Button Macro | Excel Discussion (Misc queries) | |||
| Macro Button | Excel Worksheet Functions | |||
| Macro Button | Excel Discussion (Misc queries) | |||
Linear Mode
