The Live worksheet contains formulas linked to other workbooks so in an effort to retain a static copy of the calculations at the time of saving I'm copying and pasting the Live sheet values to the Static sheet.
If I run this manually it runs fine.
If I call it from the BeforeSave or embed it into BeforeSave it steps through the lines of code but does nothing.
When BeforeSave initiates the activesheet is always Live.
Please Login or Register to view this content.
I noticed that you used codenames for the worksheet objects (Static and Live). As far as I'm aware, you shouldn't be able to use the code name "Static" as a codename for a worksheet.
I ran your code, with a small adjustment for the use "Static" to refer to the worksheet name instead and it seems to be working on my end. Not too sure what's going on on your version. Are you able to send the original Excel file (with any important data removed of course) for us to play with?
The code I used for my testing as below:
Please Login or Register to view this content.
Last edited by quekbc; 06-23-2015 at 08:05 PM. Reason: Formatting
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks