![]() |
|
#1
|
|||
|
|||
|
On this link I wrote about my problem and I attach my file *. Xlsm When I save my Workbook as *. Xlsm in this case Workbook_Open event is functioning correctly. If I save in the file format *. Xls, in this case on re-opening the file Workbook_Open event that does not work, nothing happens? I tried to run the file in *. Xls format and after that nothing happens I've tried to run the following VBA code to check the event Code:
Sub EnableEventsNow()
Dim sMsg As String
With Application
sMsg = IIf(.EnableEvents, _
"Events were already enabled.", _
"Events are now enabled.")
.EnableEvents = True
End With
MsgBox sMsg
End Sub
Can someone help me and explain why it is not working Workbook_Open event in *. XLS file format Improved thanks for any help. Last edited by beginner; 04-11-2013 at 02:38 PM. Reason: solved problem |
| Tags |
| workbook_open |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Duplicate event reminders | rgarneau | Outlook | 0 | 01-23-2012 08:58 AM |
Create calendar event
|
groegee | Outlook | 1 | 12-05-2011 09:56 PM |
| Catch event before next slide | PetLahev | PowerPoint | 0 | 10-21-2011 03:29 AM |
| Event Log - Outlook Crashed | Davva | Outlook | 0 | 11-10-2009 01:35 PM |
| Problem with Workbook_Open with CustomUI | birdseye42 | Excel | 0 | 08-26-2009 11:59 AM |