VBA MOD01 For Each to loop through collection (Sheet , Ranges)





 Public Sub Protect_All_Sheets()

    Dim Sh As Worksheet

    For Each Sh In ThisWorkbook.Worksheets

    Sh.Protect

    Debug.Print Sh.Name

    Next Sh

    

  

   

End Sub


Public Sub Un_Protect_All_Sheets()

Dim Sh As Worksheet

For Each Sh In ThisWorkbook.Worksheets

Sh.Unprotect

Debug.Print

Next Sh


End Sub






Comments

Post a Comment

Popular posts from this blog

introduction to python CH 01

----------IMPORTING MODULES IN PYTHON---------------  ''' Author: Harry Licenced to: ABC Company ***********Thanks for reading********** ''' import os # importing the os module  print("Hello world") ====================================================================== ----------------PRACTICE PROBLEM SOLUTIONS---------------- PROBLEM 01 ''' This problem is a solution of Problem 1 of CodeWithHarry Practice Set! ''' # This is also a comment just like the above line print('''Twinkle, twinkle, little star, How I wonder what you are! Up above the world so high, Like a diamond in the sky.''') ------------------------------------------------------------------------------------------ PROBLEM 02  from playsound import playsound playsound('D:\\MyData\\Business\\code playground\\Python Course With Notes\\1. Chapter 1\\play.mp3') -------------------------------------------------------------------------------...
Read more

Day 02 Python - data types , Numbers , Operations , Type Conversions , f-Strings

https://repl.it/@appbrewery/ day-2-start  LEC 18 - Intro of todays goals  ================================================================== LEC 19 - Data Type 1 - Strings    Any thing Written in " "  (double Quotes) and ' ' (Single Quotes)   -----------------------------------------------------------------------------------------------------------------------  2 - Integers          # Any Whole number in programming is known as INTEGERS ------------------------------------------------------------------------------------------------------------------------ 3 - Float            3.145   ------------------------------------------------------------------------------------------------------------------------- 4 - Boolean  True False  #  First Letter should be capital -------------------------------------------------------------------------------------------------------------...
Read more

CH02

VARIABLE : --- a_122 = '''harry''' # a = 'harry' # a = "harry" b = 345 c = 45.32 d = True # d = None # Printing the variables print(a) print(b) print(c) print(d) # Printing the type of variables print(type(a)) print(type(b)) print(type(c)) print(type(d)) ===================================================================  
Read more