Free Excel VBA Course #23 - Event Procedures in VBA

[@alteavanloggerenberg2464]

Hi, I hope you can assist. I have a workbook with 11 sheets. How would I go about triggering a macro event that is only applicable to 7 of the worksheets. Any change in the specific 7 sheets, would then trigger the macro to run. Any assistance would be greatly appreciated.

[@kcs-dj3ec]

Sir, I have one complaint. The font of the code you write is too small to read. Pl increase/magnify the editor window.

[@kebincui]

great tutorial, thanks

[@redhaakhund1271]

Great! thank you so much for the video

[@JATINKUMAR-qu4vi]

Great video

[@margad-erdeneboldbaatar4704]

Thanks so much.

[@pravinvasudevan]

Hello Mr.Sumit, the way u teach VBA is awesome. thank you for your efforts and hardwork. cud u pls share macro of hw to freeze top row in excel where I have my first header, until I scroll down and reach a particular row where I hve another header and when this second row scroll up to reach the first row, then the second row will get freeze and the first row will get unfreeze. and again if I scroll up then the second row will get unfreeze and first row will get freeze. it should work with mouse scroll, down arrow scroll or side scroll bar. thank u so much

[@vaibhavjain6619]

I think you will use freeze pannes from view tab just normally put ur cursor below the data which you want to be freezed then go with it ,if don't want that just unfreeze the panes by again clicking on freeze pannes

[@umamaheshk6151]

i am using MS Office2007 version. I couldn't find the dropdown list which u have shown @2:06 (I found a few). What I have to do?

[@dianat.sandoval2561]

thanks!

[@sandeepkothari5000]

Dear Sumit, Great coding. I could not make the event macro in the downloaded sheet work for me. Pl chk & revert here.

[@bluex5115]

easiest way to use NOT > Target.Font.Strikethrough = Not (Target.Font.Strikethrough) .. and for all type of activate/deactivate same :)

[@calvinzhaoksp]

can I set a "Password" to open a workbook or certain worksheet in workbook with Sub Workbook_Open ? Looking forward to your reply with thanks

[@thasbiah1132]

Wouldn't the person be able to negate it by simply disabling macros?