Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Laaibah Malik   on Nov 14 In MS Office Category.

  
Question Answered By: Noah Evans   on Nov 14

You can use following VBA code:
You can change the "mysheet" with you sheet  name. It will unhide  the sheet if
it is hideen.


Sub myload()
Dim mkc1 As Error
Dim sheet1 As String
sheet1 = "mysheet"

For Each ws In Worksheets
If ws.Name = sheet1 Then
edits = 1
End If


Next ws

if edits = 0 Then
Else
If Application.Worksheets(sheet1).Visible = True Then
Else
Application.Worksheets(sheet1).Visible = True
End If
End If
End Sub

I hope it works

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on hide sheet Or get search suggestion and latest updates.


Tagged: