Accessing macros from temp file

[Jham10]

Hi everybody,


I am having an issue when opening (not downloading) my file from the website version of my company's email server, or from my company's actual corporate server itself. When I open the file, the private sub macros work. Any macros that are stored within the workbook or modules that are not private do not seem to work. I would just make all of the macros private but then I have not idea how to assign them to buttons or access them from the spreadsheet. The file also opens as read only. Not sure if that has anything to do with it, but I think that it is trying to pull the macros from a temporary file that is located remotely on the server.

I would love for a way to be able to access my macros within the workbook itself and have no issues when sharing the file to my colleagues. I also understand that there is a way to save macros into a personal folder and upload it on the server, but I was hoping there would be an easier solution that would allow the file to just work all the time and has the macros saved within it. Does anybody have any guidance on what I am doing wrong here?



Thank you very much for your help!

 

[Jham10]

Also- When I download the file to the computer and then open it, the macros work fine. They do not work when selecting OPEN not SAVE AS. This might help. Thanks again.

 

[Jham10]

Can anybody help me??!!!

 

[Jham10]

Also, I am using excel 2007.