Workbook_Open event do not working?

beginner · #1 04-10-2013, 01:23 PM

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

After activating this code (I put the cursor inside the VBA code) by pressing F5 on my keyboard, then I get the message "Events were allready enabled" means that the event has started?

Can someone help me and explain why it is not working Workbook_Open event in *. XLS file format

Improved thanks for any help.

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