Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Virginia
    Posts
    37
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Always make cell A1 visible on open

    Using code, I want to make cell A1 on sheet 1 visible when the file is open no matter how the workbook was saved. How do I do this?

  2. #2
    Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Always make cell A1 visible on open

    The following code in the ThisWorkbook code module should do what you want:

    Private Sub Workbook_Open()
    Sheets("Sheet1").Activate
    Range("a1").Activate
    End Sub


    Ian.

Posting Permissions

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