Save XLSM without running, but retaining macros
Okay, I am building an Excel 2010 spreadsheet for use as a SharePoint library template. The following VBA code is in the ThisWorkbook object.
Can I save the workbook without the scripts running, but so they will run the next time the workbook is opened via the SharePoint library?
Please Login or Register to view this content.
BTW, removed the path in the SharePointPath variable, but the code works as intended. I just mainly need to save it without the "ActiveSheet.Range("A2").Value = ActiveSheet.Range("A2").Value" line running and removing the formula in the A2 field, but that does need to run whenever a final workbook is saved to the library from the template. Anyone at all able to help with this? Internet searches have yielded nothing helpful.
Last edited by adkaraczun; 09-20-2012 at 07:07 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks