Unable to set the visible property of the worksheet class

Hi

I am trying to hide the worksheet using 02-xlsheetVeryhidden but when i try to change the visible property i am getting error as Unable to set the visible property of the worksheet class. it would be great if any one could tell me the procedure to get it done.

i have a vb project i want to hide some worksheet & there formula from another users. worksheet password can be cracked by using macro. I have already locked the project by providing password to standard module. Any best way to hide worksheet & formula's


https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgzMCQUIQgrbec400jl4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgwhVTFaD469mW9wO194AaABAg. 9gJzxwFcnPU9gORqKw5tW_
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugyb8nmKKoXvcdM58gV4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgwvvXcl1oa79xS7BAV4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgxvIFArksPprylHXYZ4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

Hi excelfun,

you can use a single line of code for hidding the sheet ie,

Code:

---

ThisWorkbook.Sheets("Sheet1").Visible = false

---

regards


https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgzMCQUIQgrbec400jl4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgwhVTFaD469mW9wO194AaABAg. 9gJzxwFcnPU9gORqKw5tW_
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugyb8nmKKoXvcdM58gV4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgwvvXcl1oa79xS7BAV4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=UgxvIFArksPprylHXYZ4AaABAg
https://www.youtube.com/watch?v=f7xZivqLZxc&lc=Ugxq4JHRza_zx3sz0fx4AaABAg
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

Hi

Could you post the whole code here?

@ prince, please use code tags while posting codes :)

Hi Admin

below code working fine for me. but if i go to visual basic editor. In project Explorer window if i select sheet3. In property window of sheet3.
visible properties are 1xlsheetvisible, 0 xlsheethidden, 2 xlSheetVeryHidden. i can not set visible property of sheet3 Manually using droup down. i get error.
but with below code i can do it.

Code:

---

Sub Test()
Sheet3.Visible = xlSheetVeryHidden
End Sub

---

Worksheets("TempParameter").Visible = xlSheetHidden ----- this is what I use

You can set Visible and Hidden by the Properties pane, but for VeryHidden it is by VBA only. It's supposed to do that. :)

Thanks Zack for this info.