View Single Post
Old 01-12-2015, 03:40 AM
TheRealTinTin's Avatar
TheRealTinTin TheRealTinTin is offline
Junior Contributor
Join Date: Nov 2008
Location: Glasgow, UK
Posts: 383

Hi george, apologies for the delay only just getting a chance to get on.

OK two things I would try. Firstly, I'd try using the BeforeClose event rather than BeforeSave. Although you're explicitly saving the workbook, I'd just test it to see if that triggers. The second thing I'd try is opening the Workbook manually, changing the value of [A1] and then saving/closing the workbook to see if it saves the new worksheet. If it does, then it has something to do with .NET and if it doesn't, then it's the code and (probably) where it's triggered.

I'll need to wait until I'm home to test .NET as we still use legacy VB in work but if it doesn't work I'll give it a bash later.
Artificial Intelligence is no match for natural stupidity
Reply With Quote