Hi,
i have a code for closing the file which suppose to choose a specific sheet and cell.
for some reason it doesn't work although it has worked before.
I've added the "Application.EnableEvents = True" command but it still not working...
thanks!
Please Login or Register to view this content.
Last edited by vlady; 11-11-2012 at 07:46 PM. Reason: code tags
It's more likely that you have switched off Event handling elsewhere and, for some reason, it is not getting switched back on.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
How can i find it?
I didn't use this command anywhere else...
What else can make it turn off?
Found it,
I add this command after select case, which probably made it turnes off.
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks