I have an EXCEL workbook (.xlsm) that obviously contains Macros that I wish to share via ONEDRIVE with other users, When I try it says since it has Macros it wil not work. What do I need to do?
I have an EXCEL workbook (.xlsm) that obviously contains Macros that I wish to share via ONEDRIVE with other users, When I try it says since it has Macros it wil not work. What do I need to do?
Can you provide more details?
When you try to do what? Save it? Mark it as shared? Something else?When I try it
What is the exact error message and how is it presented to you, from what application? Is this a OneDrive message?it says since it has Macros it wil not work
You should be able to share a file with macros on OneDrive or any other file-sharing cloud service (Dropbox, Google Drive, etc.) and the macros will work for other users. However, if the other user is opening the file in a web-browser version of Excel (which is the default for SharePoint users, for example) then macros won't work.
So we need more information about exactly what you are seeing, the environment you are in, and whom you are trying to share with.
Also: Your account is old with only a few posts. Please check your profile and update as needed--are you really still using Excel 2003?
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
I hopefuly updated my info. Thanks for asking.
What seems to happen is we shared and saved my program with Macros to onedrive. An email is sent to the second PC where when I click on it it then asks if want to use web or load program which we do. The sheet opens up but no data is shown and it says Does not support Macros.
Does that help?
I am not clear on what this means
"asks if want to use web or load program which we do."
or what happens next
Sorry what I mean is when i get the email link I click on it and it says do I want the web or excel version. I click on excel which then opens the program correctly but no data flows and get message about not supporting macros.
If you can time or we can chat let me know and I will give you my phone number
I am not sure why you would get that message if you are opening the file in the desktop version of Excel. I have seen that only in the web version.
I would like to see the exact wording of the message. Does it tell you that macros are not enabled, or something else?Originally Posted by 6StringJazzer
I'm sorry but this is not a paying job and I just can't possibly schedule calls with everyone who asks.
Last edited by 6StringJazzer; 02-10-2023 at 01:07 PM.
Of Course sorry I even asked. I really appreciate your comments and I am stumped as well. Not sure why the data that is active ands showing on 1 PC doesn't show up on the second and even when trying to type into the data fields it will not accept since no macros. This is nuts.
Again thanks anyway for your comments and interest so far.
The only thing I can think of is that you have to allow that file or location to be a safe location for running macros. It would be in the security settings for Excel. But it depends on what error message you are getting.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks