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
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
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.
great tutorial, thanks
Great video
Great! thank you so much for the video
easiest way to use NOT > Target.Font.Strikethrough = Not (Target.Font.Strikethrough) .. and for all type of activate/deactivate same :)
Thanks so much.
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
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
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.
Sir,
I have one complaint. The font of the code you write is too small to read. Pl increase/magnify the editor window.
thanks!
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?
Dear Sumit, Great coding. I could not make the event macro in the downloaded sheet work for me. Pl chk & revert here.
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
Wouldn't the person be able to negate it by simply disabling macros?