|
|
|
|
#1
05-04-2014, 02:12 AM
|
|||
|
|||
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 
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 From an XL sheet ,how to keep the group of columns which match with other XL sheet
|
Zubairkhan | Excel | 2 | 03-04-2014 10:57 PM |
| sheet 2 data highlight in sheet 1 | gsrikanth | Excel | 1 | 04-21-2012 06:25 PM |
|
Construct a summary sheet by summing up from one or more than one sheet.
|
PRADEEPB270 | Excel | 1 | 11-04-2011 03:46 AM |
| Hiding text | Reg06 | Visio | 0 | 01-15-2011 08:04 AM |
| copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |
Windows 7 64bit 
Office 2010 32bit
Hybrid Mode