Hyper link for hidden sheet| How To Hyperlink to a Hidden Worksheet - Excel VBA |Excel |

[@masdedikariwibawa1533]

Thank you very much sir, this really helped me in doing my assignment. keep working, I hope your channel will be successful.

[@ruchavyas1916]

Does it allow to change data in hidden sheet after providing hyperlink

[@manojkumarexcel]

Yea

[@niharikanayak2843]

Sir, I want to apply this programme for my requirement. Will be it work or will have to change words as per my report name.. please tell me

[@manojkumarexcel]

You have to change name as per your sheet name

[@zain1991]

hi...
i have tried to hide hyperlink sheets in vba. i have used this programming,
Dim shtname As String
shtname = Left(Target.SubAddress, InStr(1, Target.SubAddress, "!") - 1)
Sheets(shtname).Visible = xlSheetVisible
Sheets(shtname).Select
i have applied same code but it is not working. it shows choose some macros enabled file. my sheets name are ventilation, transitional, minimum ventilation, management.
please guide me Regards

[@manojkumarexcel]

Send your sheet
[e-mail]

[@zain1991]

@@manojkumarexcel ok I’ll thanks for response

[@manojkumarexcel]

Welcome

[@zain1991]

@@manojkumarexcel i have sent you an email kindly check and response please

[@zain1991]

@@manojkumarexcel have you please checked my file??

[@freefiregang1275]

I want to apply this coding for Accounting like ledger. I prepared folio no. and used hyperlink to search specific sheet where account of people. and back to index sheet. But it doesn't working. there are many sheets already for other purpose inside entire workbook.

[@manojkumarexcel]

Thanks for giving your feedback
Cont me Or send your sheet to
[e-mail]

[@freefiregang1275]

@@manojkumarexcel I've sent my sheet can you help to solve my problem

[@freefiregang1275]

Please check the latest one in mail/

[@manojkumarexcel]

Ok

[@manojkumarexcel]

Can you send one more times

[@sayedsuhailrahmankhanjar4928]

Hi dear Sir
Can u explain me about hidden sheets due hyperlink when we have a form table in query command with several sheets
Note: if it possible without of vba
best regard
Suhial

[@manojkumarexcel]

Sure

[@manojkumarexcel]

Share me your sheet
[e-mail]

[@RameshSharma-hr9bp]

Sir, I follow all steps , it's working but closed the save sheet and reopen then it's not working

[@manojkumarexcel]

Save as macro enable sheet

[@abdurahmanbasunbul2065]

Dear sir,
I followed all the steps, but when i hide the sheet does not access

[@rvsnraju123]

sir, can you please explain same concept in ms word to make one paper index for a book .

[@manojkumarexcel]

Sure

[@pradeepmoharana]

Dear Sir, I am getting Runtime error 9 if i am applying the code

[@manojkumarexcel]

Contact me
[e-mail]

[@pradeepmoharana]

@@manojkumarexcel Sent You one email Sir Yesterday from Pradeep Moharana mail Id

[@kasidmalik6413]

Sir kya hm kisi linc ko MSG ke andr hide kr skte h

[@sumitmaskey42u]

I have tried many times but not been successful. Help to fix this issue

[@manojkumarexcel]

contact me
[e-mail]

[@kismatmagar2406]

Same here please help me too

[@rajeshray2019]

Apne sahi btaya hai but jab mai application karta hu to mujhe error show ho rha hai kya kare VBA coding ko save karta hu to nhi save hota hai

[@manojkumarexcel]

Contact me
[e-mail]

[@rajeshray2019]

@@manojkumarexcel ok sir

[@amitsaharkar1875]

I have applied below
linkto = Target.SubAddress
wherebang = InStr(1, linkto, "!")
If wherebang " WRITE GRATER SYMBOL"0 Then
mysheet = Left(linkto, wherebang - 1)
Worksheets(mysheet).Visible = True
Worksheets(mysheet).Select
myaddr = Mid(linkto, wherebang + 1)
Worksheets(mysheet).Range(myaddr).Select
End If
But it is not working.

[@amitsaharkar1875]

Sheet is not unhiding

[@manojkumarexcel]

Contact me
[e-mail]

[@arvinddeopandey91]

I have tried but the Syntex is not working

[@manojkumarexcel]

Contact me
[e-mail]

[@vdrsports2070]

sir google sheet ka batiyen

[@manojkumarexcel]

[e-mail]

[@mrvideos188]

sir not working

[@SONUSHARMA-fd3ew]

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
Worksheets("sheet1").Select
Target.Parent.Worksheet.Visible = False
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub
SIR ESA KRNE PAR SECOND LINE YELLOW AA RHI H OR RUN TIME ERROR 1004 DIKHA RHA HAI AUTO HIDE NHI HO RHI SHEET

[@manojkumarexcel]

Contact me
[e-mail]

[@Vilas_Patil0224]

No

[@Vilas_Patil0224]

Not working

[@manojkumarexcel]

Contact me
[e-mail]

[@AkhileshSingh82]

Its not working Sir

[@manojkumarexcel]

Can u share me your sheet we need to see why not working
[e-mail]

[@TSGuideMan]

Nhi huwa sir

[@manojkumarexcel]

Thanks for your feedback
Send me ur file
[e-mail]
We need to see why not working

[@TSGuideMan]

@@manojkumarexcel office vr 2007 me

[@manojkumarexcel]

Ok share ur file