Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Don't print Cell A1 (Excel 2002)

    Hi

    Is the a way to prevent just cell A1 from printing on a particular worksheet?


    Many Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Don't print Cell A1 (Excel 2002)

    Set the print range for that worksheet to a range that does not include A1.

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Don't print Cell A1 (Excel 2002)

    Hi Hans


    Thanks for that but my problem is, this cell is protected in visual basic to prevent it being deleted, but I do not want it to print.

    Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    If Not Intersect(Target, Range("A1")) Is Nothing Then
    With Application
    .EnableEvents = False
    .Undo
    .EnableEvents = True
    MsgBox "'Cell A1' may not be changed"
    End With
    End If
    End Sub

    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Don't print Cell A1 (Excel 2002)

    What is wrong with my suggestion to set the print area?

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Don't print Cell A1 (Excel 2002)

    Hi Hans

    I did as you suggested, set the print range from row 2 but A1 still came out on the print out!!

    Braddy
    If you are a fool at forty, you will always be a fool

  6. #6
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Don't print Cell A1 (Excel 2002)

    Hi Hans

    I am sorry I had a senior moment, it was page setup it was set to repeat from row 1 to 12.

    Humble apologies

    Braddy

    <img src=/S/blush.gif border=0 alt=blush width=15 height=15>
    If you are a fool at forty, you will always be a fool

Posting Permissions

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