Hello. Could someone explain this code? What does "private" and "change" mean? What about the rest? Thanks. Stepped through it but didn't really understand.
Please Login or Register to view this content.
Hello. Could someone explain this code? What does "private" and "change" mean? What about the rest? Thanks. Stepped through it but didn't really understand.
Please Login or Register to view this content.
Last edited by freshfruit; 02-14-2014 at 01:05 PM.
Private hides the macro from the lists of macros shown when bring up the user-visible macro list. (Alt-F8)
Worksheet_Change is simply the special name of this event macro. You can probably Google up lots of straightforward tutorials on that.
LA Baby?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks