+ Reply to Thread
Results 1 to 5 of 5

showing / hiding gridlines through VB code

  1. #1
    archeti
    Guest

    showing / hiding gridlines through VB code

    can anyone kindly tell me if there is any way by which I can change the hide
    / show gridlines property of a workbook through VB code. I guess there must
    be a system variable for this.

    thanks

  2. #2
    Gary''s Student
    Guest

    RE: showing / hiding gridlines through VB code

    To hide gridlines use:

    ActiveWindow.DisplayGridlines = False
    --
    Gary's Student


    "archeti" wrote:

    > can anyone kindly tell me if there is any way by which I can change the hide
    > / show gridlines property of a workbook through VB code. I guess there must
    > be a system variable for this.
    >
    > thanks


  3. #3
    Harald Staff
    Guest

    Re: showing / hiding gridlines through VB code

    Record a macro while doing it manually and you have a good start. It is a
    Window-per-worksheet setting, not a Workbookwide setting, which makes it a
    little confusing to handle.

    HTH. Best wishes Harald


    "archeti" <archeti@discussions.microsoft.com> skrev i melding
    news:6C0BDEE0-C4E9-4230-A16B-C267F7835504@microsoft.com...
    > can anyone kindly tell me if there is any way by which I can change the

    hide
    > / show gridlines property of a workbook through VB code. I guess there

    must
    > be a system variable for this.
    >
    > thanks




  4. #4
    John
    Guest

    Re: showing / hiding gridlines through VB code

    Morning Archeti,

    Gridlines are a property of the Window object, so:

    Application.ActiveWindow.DisplayGridlines = False

    Best regards

    John

    "archeti" <archeti@discussions.microsoft.com> wrote in message
    news:6C0BDEE0-C4E9-4230-A16B-C267F7835504@microsoft.com...
    > can anyone kindly tell me if there is any way by which I can change the
    > hide
    > / show gridlines property of a workbook through VB code. I guess there
    > must
    > be a system variable for this.
    >
    > thanks




  5. #5
    archeti
    Guest

    RE: showing / hiding gridlines through VB code

    thanks to all

    "Gary''s Student" wrote:

    > To hide gridlines use:
    >
    > ActiveWindow.DisplayGridlines = False
    > --
    > Gary's Student
    >
    >
    > "archeti" wrote:
    >
    > > can anyone kindly tell me if there is any way by which I can change the hide
    > > / show gridlines property of a workbook through VB code. I guess there must
    > > be a system variable for this.
    > >
    > > thanks


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1