View Single Post
 
Old 05-04-2014, 02:12 AM
NobodysPerfect NobodysPerfect is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Jan 2014
Location: Germany
Posts: 136
NobodysPerfect is on a distinguished road
Default

Thanks for your answer.

Yes, i did - several times and always the same result: if Workbook_BeforeClose is triggered using the SaveWithChanges button, the sheet isn't hidden, while it is whenever I select "Close" or closing "X".

What really strikes my: all other code lines are executed, the macro runs through the 'hide' code line, too, but the sheet isn't hidden.

I found the same problem here:
http://www.ozgrid.com/forum/showthread.php?t=150539 ... unfortunately without a real solution.

NP
Reply With Quote