Results 1 to 2 of 2

Thread: vba, worksheet visible issue

  1. #1

    vba, worksheet visible issue

    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???

    Code:
    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
    Any help would be really great

  2. #2
    Hi,

    Please forget this post. There is a problem mith my settings I think (don't know what) but all others can use the workbook fine with no issues, the code is fine.

Similar Threads

  1. Date COlumn AutoFiltering Issue!
    By labkhand in forum Excel Help
    Replies: 3
    Last Post: 11-06-2013, 01:41 AM
  2. Replies: 4
    Last Post: 05-05-2013, 04:01 AM
  3. Print Nth Worksheet To Mth Worksheet using VBA
    By Ryan_Bernal in forum Excel Help
    Replies: 2
    Last Post: 02-28-2013, 06:57 PM
  4. SharePoint Hyperlink issue
    By PeteRooney in forum Excel Help
    Replies: 0
    Last Post: 10-30-2012, 03:25 PM
  5. Replies: 7
    Last Post: 06-09-2012, 06:45 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •