Hi all, xlsSheet = CType(xlsWB.Sheets(“HideSheet Name”), Microsoft.Office.Interop.Excel.Worksheet) xlsSheet.Visible = True NOT : This code gives me an error => convertion error boolean to XlSheetVisibility How can i do unhide specific sheet or sheets from excel via invoke vb.net ?? Thanks.

[image] yigit.aybey: xlsSheet.Visible = True Hi @yigit.aybey , Maybe changing the above to the below Expression would work : xlsSheet.Visible = Microsoft.Office.Interop.Excel.XlSheetVisibility.xlSheetVisible Let us know if it results in an error.

Doing Unhide in Excel sheet/s

Help Studio

Gokul001 (Gokul Balaji) October 6, 2022, 10:55am 4

Why do need in Invoke code do you have any specific reason?

Check out the thread

Regards
Gokul

2 Likes

Topic		Replies	Views
Invoke Code (VB.Net) Activity to hide some Excel sheets Studio excel , studio , question , vbnet , invoke-code	3	2123	July 14, 2021
Invoke code to get hidden sheets in an excel file Activities excel , activities , question	10	1758	December 22, 2021
Invoke Code for ActiveSheet Name Help	3	2091	April 4, 2019
Unhide columns/rows if present in excel sheet Studio excel	7	861	October 9, 2022
Hide and unhide sheet in vb.net Activities excel	2	1030	September 18, 2021

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

Doing Unhide in Excel sheet/s

Related Topics