Hi
I have this code in one of my sheetThe problem is once i put it in my sheet, The undo button greys out
Please Login or Register to view this content.
Is there any possibility to use the undo button after having this code in the sheet?
Can anyone alter the vba code so as to enable the undo click?
Thanks in advance!!
You can't use undo button everytime you execute a macro.
Read this;http://www.jkp-ads.com/Articles/UndoWithVBA00.asp
Last edited by Blokeman; 01-22-2015 at 12:39 AM.
Please click the * Add Reputation if this helps
If solved remember to mark Thread as solved
"I'm glad to help and this is not meant to sound smart, but either you have super-human vision to see all those controls cleared one by one with the code I posted, or your computer is really slow."
yeah but i read that its possible if u alter the code, since i know only basic of vba, is it possible to later the above code??
Try this:
And then put this in a Standard Module (it won't work if you put it with the worksheet code above).Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by mgs73; 01-22-2015 at 01:12 AM.
hey sorry i dont know much about vba, should i use both the codes at once? what is standard module?
Last edited by Masa1989; 01-22-2015 at 01:15 AM.
Yes.should i use both the codes at once?
In the VBA Window on the Left Side, look for something that says 'Microsoft Excel Objects'. Right-click there and select Insert then Module. This is a 'standard' module as opposed to a workbook or worksheet module.what is standard module?
hey yeah i found, do i use the above codes one below each other??
he y i was tryin this code, it only unhides the hidden columns and undo in general doesnt get enabled
In that case, I am afraid what you are asking for is impossible.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks