Good Morning!

I am stumped on compatibility between Excel 2010/2013 and Sharepoint. I have a spreadsheet that I've been working on, which is for monitoring attendance records. I have VBA code that emails each GM their list of absences for employees that work under them. It works beautifully on my computer (Windows 7, Office 2010, local). It gets wonky on the HR person's computer (Windows 7, Office 2013, SharePoint).

Issues: I used to have separate passwords for my worksheets (which HR does not need access to) and HR worksheets (worksheets she needs access to, but not viewable by anyone else). Because of a conflict with Office 2013, I changed all passwords to worksheets and VBA code to her password. Now, for some reason, the application resets my passwords on her worksheets randomly. I have changed all passwords on the live version, then downloaded it from SharePoint for testing purposes. I retrieved the file this morning, and my passwords were on her worksheets again (very aggravating).

Next issue, the code below works perfectly on my computer. For some reason, Office 2013 has turned off Macros, so she has to run macros from the ribbons, View, View Macros, and then select the macro from the window. I don't have to do that. At least I didn't, until she saved it and now I have to.

Last issue is the code below outputs blank worksheets for her, and opened separate excel files that she could see but not email. On my desktop, the macro worked perfectly.

Any ideas on what may be going on here based on user experience?

Thanks so much!

Code Follows:

Please Login or Register  to view this content.