LinkBack URL
About LinkBacks
I put this in the "Workbook":
Please Login or Register to view this content.
-- But is says that "EventMacro" cannot run? Can anyone help me out?
I put this in the "Workbook":
Please Login or Register to view this content.
-- But is says that "EventMacro" cannot run? Can anyone help me out?
Last edited by Lv27; 05-07-2012 at 02:49 PM.
place the code inside (Alt + F11) and paste This_Workbook
Please Login or Register to view this content.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
You should put your code in CODE tags. Please read the forum rules for clarification.
While you are doing that, consider that you need to put the EventMacro and the CloseMacro in a standard module, not in the Workbook Class module.
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
Tried putting "EventMacro" and "StandardMacro" in the standard module instead and now it works! Thank youWill read the forum rules... Am new here
You're welcome. And welcome to the forum! Please add code tags to the original post as, otherwise, the moderators could reprimand us both
Haha we definitely can't have that - I have added the code tags as requested
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks