Thank you so much for this code, it worked like a charm after I set the starting row to 3 instead of 5 and inserted column A in my spread sheet as the Identifier Column. I am only vaguely familiar with VBA, enough to make slight modifications but not to write my own code so this helped me a lot!!
@IntegratedSchoolForms
3 жыл бұрын
Glad that it helped you out! It makes a lot of our tasks a lot easier, right?
@titsergie5484
2 жыл бұрын
Thank you soo much sir. This is great help for us aspiring teacher who wants to make our own template. ❤️
@HeyKimmi
5 ай бұрын
Do you have the code somewhere that we would use to 'reshow' the rows that were hidden? I tried to do the Ctrl + A, then right click and choose unhide, but the other rows did not reappear
@IntegratedSchoolForms
5 ай бұрын
That would initially happen when pressing Ctrl + A while within the range of your data to only highlight the selected range and not the whole sheet (document sheet). The easier way would be to use the macro recording tool in Excel which I also mentioned in the demonstration, pressing Ctrl + A and checking if the whole document sheet is indeed selected and if not then press it again to highlight everything in the sheet. Right click on any of the rows and choose unhide. Once all the rows are visible, stop the macro recording and assign a button or a keystroke for that particular VBA. hope that helps
@maheshborle36
3 жыл бұрын
Hello sir I am so thankful to you for this video But actually the code which you mentioned in this video is not working in our sheet . The same i copied as you told but it wasn't working and second if I want to do the same hiding process in same sheet at multiple places then how will it be done ? I hope for your answer soon
@IntegratedSchoolForms
3 жыл бұрын
have you tried viewing the link in the description box to have the code and copy/paste it immediately?
@shrutiborle3487
3 жыл бұрын
@@IntegratedSchoolForms yes sir I did the same
@IntegratedSchoolForms
3 жыл бұрын
@@shrutiborle3487 i see.. that's a bit weird.. i've been using this code and alter the values of the cells in the macro depending on where i place the conditional values in the sheet. i suggest you go back to the process in the video just in case you miss part of it.
@shrutiborle3487
3 жыл бұрын
@@IntegratedSchoolForms no sir I did as you directed in video also checked many times but still not working
@shrutiborle3487
3 жыл бұрын
@@IntegratedSchoolForms thanku so much sir there was a little mistake in my code.. I rectified it But I have one more query that how can I unhide these blank spaces with just one click on that same hide button ? I'll be waiting for your reply
@normeldeasis1035
3 жыл бұрын
Good evening Sir, i am so blessed to have a soft copy of your isf v5 because it would be so helpful for me as an elementary teacher. unfortunately i can't use it Sir because i can't input my learners' data as it requires a password to unprotect the sheets. It would be a great help for me Sir, I'm hoping for your kind response Sir.. thank you so much and God bless you Sir.
@IntegratedSchoolForms
3 жыл бұрын
Have you tried using the latest version of the iSF which is at v 6.2.1?
@normeldeasis1035
3 жыл бұрын
@@IntegratedSchoolForms thanks for the reply Sir. I don't have it yet Sir (v 6.2.1) I'm still watching your tutorial videos on isf right now.
@IntegratedSchoolForms
3 жыл бұрын
@@normeldeasis1035 if I remember it correctly, version 5 was released 2018... that’s quite old already
@normeldeasis1035
3 жыл бұрын
@@IntegratedSchoolForms yes sir, i just downloaded now the version 6.2 sir..iLL open ds tomorrow..hop it'll work out..thank you for your effort sir.. Godspeed
@Daddyjackson20000
Жыл бұрын
Is there a way to have another button that unhides everything???
@IntegratedSchoolForms
Жыл бұрын
you may do that by following the same instruction on making a button but instead of typing the vba codes, you may just use the record macro button.
@rickymartin4952
2 жыл бұрын
Can you tell me what is wrong here with this Error ? i tried to copy and paste your attached code but it didn't work , so i'm trying to type it in. Rick Martin
@IntegratedSchoolForms
2 жыл бұрын
have you tried clicking the debug option in the vba window?
@MRGACCOUNTING
Жыл бұрын
Hello Sir, I tried this and when I run debug it says Run time error 5 Invalid procedure call or argument
@IntegratedSchoolForms
Жыл бұрын
where exactly did VBA marked the error? Sometimes, there's an issue with the apostrophes " " copy pasted from the website and then to VBA window. Excel doesn't recognize the apostrophe from the website, so, try editing the apostrophes in the VBA windows instead. Hope that helps.
@MRGACCOUNTING
Жыл бұрын
@@IntegratedSchoolForms at first I to write all the code in VBA window same error and same erro when i copy paste.
@IntegratedSchoolForms
Жыл бұрын
this going to be very difficult to picture out without having a good look at the file you're working on. how about trying to use the codes first without altering anything, based on the arrangement of the template, see if that works.
@MRGACCOUNTING
Жыл бұрын
@@IntegratedSchoolForms oo nga po, wala kasi option to attach screen shot sa comment section
@mkanniappan9804
11 ай бұрын
how to hide column pls send code
@IntegratedSchoolForms
11 ай бұрын
you can simply just use the macro recording option. turn on record macro, press ctrl-A, then click on any row and choose to unhide.
Пікірлер: 27