OMG! You are a legend. Do you know I have been on the phone for hours trying to recover the previously saved files because I hadn't realised I have somehow hidden all my sheets and the unhide option was not working. I did not know about this view code option to unhide sheets. Not even Microsoft support told me this! You are a legend, seriously so baffled how Microsoft support didn't even know this was an option. THANK YOU!!!!!!!!
I had a data validation tab I couldn’t un hide using the “right click the bottom” method. I never knew about the VBA but your explanation was so helpful! I was able to unhide the tab I needed to and not go insane lol. Thanks!!
Hi Sumit.. thanks for the video. Love the Immediate Window in the VBE and VB in general.. gives so many ways to solve simple problems on the fly and also complex problems, as well. Thanks for sharing your tips. Thumbs up!
hello sumit thanks for your video. using userform. can add - + for example. sumit to paid 100, sumit have paid 100. to paid have paid to paid sumit 100 - 100 0 can do so when using userform?
WARNING! Check to make sure your filetype is NOT .csv. Excel will let you split your csv file into multiple worksheets, save the file, and close the file, all without warning you that the .csv datatype does NOT support multiple sheets. Upon re-opening your .csv file, you'll be pleasantly surprised to learn that ALL OF YOUR WORKSHEETS EXCEPT FOR ONE OF THEM HAS BEEN PERMANENTLY DELETED. Thanks Microsoft, for wasting hours of my fucking life. Moral of the story: use google sheets instead.
OMG! You are a legend. Do you know I have been on the phone for hours trying to recover the previously saved files because I hadn't realised I have somehow hidden all my sheets and the unhide option was not working. I did not know about this view code option to unhide sheets. Not even Microsoft support told me this! You are a legend, seriously so baffled how Microsoft support didn't even know this was an option. THANK YOU!!!!!!!!
Very nice solution to a very annoying problem 👌
This is AWESOME!!!! Thank you very much!!!!
Your tips are really useful.
I had a data validation tab I couldn’t un hide using the “right click the bottom” method. I never knew about the VBA but your explanation was so helpful! I was able to unhide the tab I needed to and not go insane lol. Thanks!!
Thank you so much for this great tip!
Hi Sumit.. thanks for the video. Love the Immediate Window in the VBE and VB in general.. gives so many ways to solve simple problems on the fly and also complex problems, as well. Thanks for sharing your tips. Thumbs up!
Thanks for sharing, Sumit.
Un-hiding several worksheets are a real pain. Thanks for the tip.
Excellent work..
Great
Great initiative sumit....
Y DNT you start VBA programming sir...ur explaining super
Good one!
Great Trick !
THX !
Very usefull
Thank you
Very Nice
Great....
Thanks
hello sumit
thanks for your video.
using userform. can add - + for example. sumit to paid 100, sumit have paid 100.
to paid have paid to paid
sumit 100 - 100 0
can do so when using userform?
found many video similar to liela gharani.
Hi, I am having runtime error '1004'
Hello! Me too...
WARNING! Check to make sure your filetype is NOT .csv. Excel will let you split your csv file into multiple worksheets, save the file, and close the file, all without warning you that the .csv datatype does NOT support multiple sheets. Upon re-opening your .csv file, you'll be pleasantly surprised to learn that ALL OF YOUR WORKSHEETS EXCEPT FOR ONE OF THEM HAS BEEN PERMANENTLY DELETED. Thanks Microsoft, for wasting hours of my fucking life.
Moral of the story: use google sheets instead.
Just use WPS office, Easy ! 🥴
You can unhide all by press Shift + drag down +press ok