Hello,
I wrote a lot of code for a workbook which works brilliant on my local computer. I moved the file to a network drive so others could use it but as soon as I accessed the file from the network drive my code kept getting debugged with errors. one of which is making a sheet visible as follows. Don't know whats wrong as I just changed the file location???
Any help would be really greatCode:Private Sub Workbook_Open() Application.DisplayAlerts = False Application.Visible = True ActiveWorkbook.Worksheets("Data (Current Month)").Visible = True ActiveWorkbook.Worksheets("Jan").Visible = False ActiveWorkbook.Worksheets("Feb").Visible = False ActiveWorkbook.Worksheets("Mar").Visible = False ActiveWorkbook.Worksheets("Apr").Visible = False ActiveWorkbook.Worksheets("May").Visible = False ActiveWorkbook.Worksheets("Jun").Visible = False ActiveWorkbook.Worksheets("Jul").Visible = False ActiveWorkbook.Worksheets("Aug").Visible = False ActiveWorkbook.Worksheets("Sep").Visible = False ActiveWorkbook.Worksheets("Oct").Visible = False ActiveWorkbook.Worksheets("Nov").Visible = False ActiveWorkbook.Worksheets("Dec").Visible = False End sub![]()


Reply With Quote

Bookmarks