excel vba workbook_open event does not work help please
 

at some point (i dont remember when exactly since i modify my code al
the time and this went unnoticed) the workbook_open event ceased t
work. all other events do work just fine so i'm guessing its no
because of the enablevents. just to make sure i saw that on th
immediate window and it was fine.
but it is very important that my workbook_open works because i need t
check if the user has a license to use the sheet, otherwise close it.
i followed a very interesting threa
(http://www.excelforum.com/showthread...&pagen umber=
) in which this person had the very same problem.
any help appreciated
thank

--
Message posted from http://www.ExcelForum.com

excel vba workbook_open event does not work help please
 

Hi
you may post your code of your workbook_open event

And just in case: You have put this code in your workbook module?

--
Regards
Frank Kabel
Frankfurt, Germany

"newyuppie " schrieb im
Newsbeitrag ...
at some point (i dont remember when exactly since i modify my code
all
the time and this went unnoticed) the workbook_open event ceased to
work. all other events do work just fine so i'm guessing its not
because of the enablevents. just to make sure i saw that on the
immediate window and it was fine.
but it is very important that my workbook_open works because i need
to
check if the user has a license to use the sheet, otherwise close it.
i followed a very interesting thread

(http://www.excelforum.com/showthread...459&perpage=15
&pagenumber=1
) in which this person had the very same problem.
any help appreciated
thanks


---
Message posted from http://www.ExcelForum.com/

excel vba workbook_open event does not work help please
 

Have you just upgraded Excel?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Frank Kabel" wrote in message
...
Hi
you may post your code of your workbook_open event

And just in case: You have put this code in your workbook module?

--
Regards
Frank Kabel
Frankfurt, Germany

"newyuppie " schrieb im
Newsbeitrag ...
at some point (i dont remember when exactly since i modify my code
all
the time and this went unnoticed) the workbook_open event ceased to
work. all other events do work just fine so i'm guessing its not
because of the enablevents. just to make sure i saw that on the
immediate window and it was fine.
but it is very important that my workbook_open works because i need
to
check if the user has a license to use the sheet, otherwise close it.
i followed a very interesting thread

(http://www.excelforum.com/showthread...459&perpage=15
&pagenumber=1
) in which this person had the very same problem.
any help appreciated
thanks


---
Message posted from http://www.ExcelForum.com/