Workbook_Open event do not working?

**Dumy** · 04-10-2013, 05:04 AM

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

Please Login or Register  to view this content.

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.

[EDIT]
Instead of the word "Sat" should be "Sub"

Please Login or Register  to view this content.

**:) Sixthsense :)** · 04-10-2013, 05:15 AM

Not sure what is sat

Sat EnableEventsNow ()

on vba window press Ctrl+G and in goto window type

Please Login or Register  to view this content.

and press enter

**Dumy** · 04-10-2013, 03:57 PM

Originally Posted by :) Sixthsense :)

Not sure what is sat

It is a procedure to check if the macro is activated, I think, I did find on the internet this macro and this is OK

Originally Posted by :) Sixthsense :)

on vba window press Ctrl+G and in goto window type

Yes, but nothing happens. Record file and again the same problem.

Please see attach
Thanks advance

**Dumy** · 04-10-2013, 04:19 PM

Originally Posted by :) Sixthsense :)

Not sure what is sat

sorry, this is "Sub EnableEventsNow()"

**:) Sixthsense :)** · 04-11-2013, 01:58 AM

Just one question before stepping into the code further...

What happens if the user Disable the Macros at the time of opening the file? They can just like that enter in to your file! One suggestion after doing all those things Protect your Project with the password and Keep a welcome sheet in Open, since One Sheet Needs to be kept in open. So that eventhought the user bypass the macros they can't see anything which is made in the file without supplying proper password or they don't have the password of the project to view or do the changes.

**Dumy** · 04-11-2013, 04:09 AM

Originally Posted by :) Sixthsense :)

Just one question before stepping into the code further...

What happens if the user Disable the Macros at the time of opening the file?

In this case, the user can not see the other worksheets because they "xlSheetVeryHidden"
I hope that there is a possibility to create a protection in this case

When accessing the Workbook Sheet1 is just visible.
If LimitDate is OK and correct password is entered then other sheets are visible

BTW: There is one problem.
There must be a way that in the event that the Limitdate expired, then only the author of the file can be accessed in the workbook, using the own password

I imagined it like this.
Case when Limitdate expired
The user opens the workbook, it appears a dialog window in which ask for a password. If Limitdate expired VBA automatically sets a new password known only to the author file. Excel workbook automatically save workbook with a new access password

Thank you that you have a desire to help me