શિક્ષક/વિદ્યાર્થી દૈનિક હાજરી
ફીટ ઇન્ડિયા રજીસ્ટ્રેશન
શાળા ઇકો ક્લબ માહિતી
➯ અહીં એક્સલ સીટમાં લગાવેલ પાસવર્ડ ભૂલી ગયા તો આ કોડની મદદથી એ પાસવર્ડ અનલોક કરી શકાશે.
➩je protect sheet no password todvo hoi tene select kro
Alt+f11 key press kro
open thase visual basic aditor
select
project explorer(ctrl+R)
select sheet and right click to select view code
and type code
press f5 key to display sheet password
remember passward and enter to unlock sheet
➩Now Click on the Run Button or press F5:
➯ Hide All Worksheets Using VBA
Below is the VBA code that will hide all the worksheets except the current/active worksheet:'This macro will hide all the worksheet except the active sheet
Sub HideAllExceptActiveSheet()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
If ws.Name <> ActiveSheet.Name Then ws.Visible = xlSheetHidden
Next ws
End Sub
➯If you want to hide the sheets so that these can not be unhidden, use the below code:
'This macro will hide all the worksheet except the active sheet
Sub HideAllExcetActiveSheet()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
If ws.Name <> ActiveSheet.Name Then ws.Visible = xlSheetVeryHidden
Next ws
End Sub
➯Unhide All Worksheets Using VBA
Below is the code that will unhide all the hidden worksheets in the workbook.'This code will unhide all sheets in the workbook
Sub UnhideAllWoksheets()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Visible = xlSheetVisible
Next ws
End Sub
