W
wrbmab
Can I create a macro in one of my spreadsheets and send it to another user so
they could use it on their adta in their computer?
they could use it on their adta in their computer?
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jacob Skaria
Yes you can. The macro code is stored within the workbook itself...
J
Jacob Skaria
Yes you can. The macro code is stored within the workbook itself...
W
wrbmab
Jacob, thanks for the info. I asked the wrong question. We receive a data
spreadsheet at multiple work stations each morning. I have created a macro to
sort this data and put it into the format we want to see it in. Is it
possbile to give this macro to the other users/workstations in my area. I
hope this makes sense, sorry for the confusion.
spreadsheet at multiple work stations each morning. I have created a macro to
sort this data and put it into the format we want to see it in. Is it
possbile to give this macro to the other users/workstations in my area. I
hope this makes sense, sorry for the confusion.
W
wrbmab
Jacob, thanks for the info. I asked the wrong question. We receive a data
spreadsheet at multiple work stations each morning. I have created a macro to
sort this data and put it into the format we want to see it in. Is it
possbile to give this macro to the other users/workstations in my area. I
hope this makes sense, sorry for the confusion.
spreadsheet at multiple work stations each morning. I have created a macro to
sort this data and put it into the format we want to see it in. Is it
possbile to give this macro to the other users/workstations in my area. I
hope this makes sense, sorry for the confusion.
O
Otto Moehrbach
If I understand you correctly, yes. A macro is simply text. You can send
it to anyone by any means, email, mail, etc. They will have to properly
install it in their workbook, however. If they do that, the macro will work
fine. HTH Otto
it to anyone by any means, email, mail, etc. They will have to properly
install it in their workbook, however. If they do that, the macro will work
fine. HTH Otto
O
Otto Moehrbach
If I understand you correctly, yes. A macro is simply text. You can send
it to anyone by any means, email, mail, etc. They will have to properly
install it in their workbook, however. If they do that, the macro will work
fine. HTH Otto
it to anyone by any means, email, mail, etc. They will have to properly
install it in their workbook, however. If they do that, the macro will work
fine. HTH Otto
G
Gord Dibben
Place the macro in a module of a new workbook.
Save As>File Type>MS Excel Add-in
Place the add-in in a folder accessible to all users on your network.
Instruct them on how to load the add-in.
Gord Dibben MS Excel MVP
Save As>File Type>MS Excel Add-in
Place the add-in in a folder accessible to all users on your network.
Instruct them on how to load the add-in.
Gord Dibben MS Excel MVP
G
Gord Dibben
Place the macro in a module of a new workbook.
Save As>File Type>MS Excel Add-in
Place the add-in in a folder accessible to all users on your network.
Instruct them on how to load the add-in.
Gord Dibben MS Excel MVP
Save As>File Type>MS Excel Add-in
Place the add-in in a folder accessible to all users on your network.
Instruct them on how to load the add-in.
Gord Dibben MS Excel MVP
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.