Nadine1988
Board Regular
- Joined
- Jun 12, 2023
- Messages
- 62
- Office Version
- 365
- Platform
- Windows
Hello Excel Experts,
i have one last error within my file related to the following code:
So the code actually works - it's supposed to hide rows 15:16 depending on the choice in the options field.
The strange thing which is not working is that it unhides the row's as soon as i continue to fill out my excel form.
Can this be related to the protect and unprotect part of the code?
Or any other ideas?
Thanks
Nadine
i have one last error within my file related to the following code:
VBA Code:
Sub Optionsfeld38_BeiKlick()
Sheet1.Unprotect Password:="Vizrt"
If Optionsfeld38 = False Then
Rows("15:16").EntireRow.Hidden = Not Rows("15:16").EntireRow.Hidden
End If
Sheet1.Protect Password:="Vizrt"
End Sub
Sub Optionsfeld39_BeiKlick()
Sheet1.Unprotect Password:="Vizrt"
Rows("15:16").EntireRow.Hidden = False
Sheet1.Protect Password:="Vizrt"
End Sub
So the code actually works - it's supposed to hide rows 15:16 depending on the choice in the options field.
The strange thing which is not working is that it unhides the row's as soon as i continue to fill out my excel form.
Can this be related to the protect and unprotect part of the code?
Or any other ideas?
Thanks
Nadine