Function To Test An Entire Column Or Row Has Been Selected

1 minute read Function to test an entire column or row has been selected. Using ths function before commencing your macro is a great idea if the macro is using the selection as a variable range. ‘============================================================================================ ‘ ## Checks whether an entire column or row has been selected and notifies the user ‘ ‘ … Read more

Function To Test If The Active Sheet Is Protected

less than 1 minute read Function to tests if the active sheet is protected. ‘============================================================================================ ‘## Tests if the activesheet is protected ‘ ‘ If the activesheet is protected ‘ If ActiveProtected = True Then Exit Sub ‘============================================================================================ Function ActiveProtected() As Boolean ‘ If the activesheet is protected then exit sub If ActiveSheet.ProtectContents = True … Read more