Unable to set the visible property of the worksheet class

[Excelfun]

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

[princ_wns]

Hi excelfun,

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

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

[Admin]

Hi

Could you post the whole code here?

[Admin]

@ prince, please use code tags while posting codes

[Excelfun]

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.

Sub Test()
Sheet3.Visible = xlSheetVeryHidden
End Sub

[Rasm]

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

[Zack Barresse]

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

[Excelfun]

Thanks Zack for this info.