Hiding Gridlines in a OLE Excel

sfosfo Member Posts: 12
Hello,

I'm filling up an Excel through OLE. I've done lots of things to the layout but I still cannot find how to hide the gridlines. I can hide them at print (with .PageSetup.PrintGridlines) but even though there seem to be a .Displaygridlines attribute to hide them at display, NAV does not seem to recognize it. Would anyone have run into this problem before, by any chance? :mrgreen:

Stephan

Comments

  • kinekine Member Posts: 12,562
    Are you able to record macro within Excel when disabling the gridlines? If yes, try to reconstruct the VB code within NAV.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.