Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi everybody,
I'm a newbie in VBA and this is my first post in this excellent group... I already saw Chip's explanation about events - http://www.cpearson.com/excel/events.htm - as well as many posts concerning this subject but haven´t yet figured out how to implement a Workbook_BeforeClose with the Excel's native behaviour when having multiple workbooks open. I have a workbook were I need to do some validations before saving and closing (hidding some sheets, protecting some cells...). If there isn't another book open I can use Workbook_BeforeClose on the ThisWorkbook module to do those things without problems but if I have more workbooks open I don't really know how to do that. Can anyone help me, please? Thanks for your time. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with Workbook_BeforeClose event | Excel Programming | |||
Workbook_BeforeClose event and OnTime method | Excel Programming | |||
Workbook_BeforeClose event is not canceled | Excel Programming | |||
Workbook_Beforeclose vs BeforeClose Event | Excel Programming | |||
Workbook_BeforeClose Event | Excel Programming |