excel vba workbook_open event does not work help please

N

newyuppie

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.php?s=&threadid=218459&perpage=15&pagenumber=
) in which this person had the very same problem.
any help appreciated
thank
 
F

Frank Kabel

Hi
you may post your code of your workbook_open event

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

Bob Phillips

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 said:
Hi
you may post your code of your workbook_open event

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top