I truly appreciate anyone's help with this. I have scoured forums for days in search of the steps to take.
I have a worksheet (a list) with a macro button that sorts the list. I would like to access this list on my phone (excel online), and am fine without the macro function being available there, as I know it cannot be active. How can I pass it to excel online (and therefore access on phone), and then pass back to normal excel without losing the macro? Currently, excel online requests that I make an editable copy, which removes the macro, and so it is of no use in regular excel, where I would like to again sort.
Steps:
1. Upload workbook (with Macro) to excel online
2. Edit if necessary, (without Macro function)
3. In order to edit, I have to make a copy. Can this step be skipped?
4. pass workbook back to regular excel with macro untouched, so I can again make use of its function
Thanks,
Glenn
I have a worksheet (a list) with a macro button that sorts the list. I would like to access this list on my phone (excel online), and am fine without the macro function being available there, as I know it cannot be active. How can I pass it to excel online (and therefore access on phone), and then pass back to normal excel without losing the macro? Currently, excel online requests that I make an editable copy, which removes the macro, and so it is of no use in regular excel, where I would like to again sort.
Steps:
1. Upload workbook (with Macro) to excel online
2. Edit if necessary, (without Macro function)
3. In order to edit, I have to make a copy. Can this step be skipped?
4. pass workbook back to regular excel with macro untouched, so I can again make use of its function
Thanks,
Glenn
