Hey guys,
is it posible when opening a Excel file, that Excel Sheets starting with "T" gets hidden.
greetz benjamin
Hey guys,
is it posible when opening a Excel file, that Excel Sheets starting with "T" gets hidden.
greetz benjamin
Put the below under "Thisworkbook"
![]()
Private Sub Workbook_Open() Dim wSheet As Worksheet For Each wSheet In Worksheets If Left(wSheet.Name,1) = "T" Then wSheet.Visible = False If Left(wSheet.Name,1)= "t" Then wSheet.Visible = False Next wSheet MsgBox "sheets T/t hidden " End Sub
Last edited by hulpeloos; 09-10-2013 at 09:25 AM.
If solved remember to mark Thread as solved , to mark your thread as Solved select Thread Tools and click Mark thread as Solved.
I can't read the mind of my wife so then I get picture but no sound .... and then I mostly get the idea, same goes here picture your outcome and I get the idea.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks