hi all
i need ur help plz, almost all events are not working, i have excel 2010.
i tried to CTRL+G and typed "Application.EnableEvents = True" and nothing happened
example; the following simple code is not working;
please help
Please Login or Register to view this content.
thanks.
Where you are having the event code? In which code window? It should be in ThisWorkbook Code window…
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Your code works weel on my excel 2010, where did you put the code ?
If solved remember to mark Thread as solved
yes it is saved with the file it self and the ext. is ".xlsm"
when i clicked save, it is just saved without the message, did i miss anything?
thanks.
Did you add the code to the Thisworkbook object in the VBA project?
If you put the code in a standard code module it will not work.
solved, was saving it as a Module
just for my information; all events should be in "Thisworkbook object"?, i am using a lot of macros and this is the first time i use "Thisworkbook object"
thanks a lot.
Not all events, only those exposed by the Thisworkbook object should be in there.
Individual sheets have there own set of events. as do userforms.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks