<div>
Hey Harfang... 
 
Sorry for the delayed response. &nbsp;The first one you suggested did the trick. 
 
Thanks! 
MikeMc
</div>

Hey Harfang...

Sorry for the delayed response.  The first one you suggested did the trick.

Thanks!
MikeMc

<div>
<div class="content wysiwyg-content">
Hello, 
 
I am trying to format an excel object that I have embedded in an Access form. &nbsp;I have included the Microsoft Excel Lib as a reference to my project. &nbsp; 
 
Most of the standard Excel formatting commands work. &nbsp;For example, &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; objXL.worksheets(1).Columns(7).NumberFormat = &quot;$#,##0&quot; 
works fine for formatting a column to currency. 
 
I can't seem to get the gridlines to turn off. &nbsp;The standard Excel command is 
&nbsp; &nbsp; ActiveWindow.DisplayGridlines = False 
Which returns the error: &quot;Object variable or WIth block variable not set&quot; 
 
I've tried a few different iterations: 
&nbsp; &nbsp;objXL.worksheets(1).DisplayGridlines = False 
&nbsp; &nbsp;objXL.worksheets(1).ActiveWindow.DisplayGridlines = False 
but none of them worked. 
 
Any help would be greatly appreciated. 
 
Thanks! 
MikeMc 
 
&nbsp; &nbsp;
</div>
</div>

Hello,

I am trying to format an excel object that I have embedded in an Access form.  I have included the Microsoft Excel Lib as a reference to my project.  

Most of the standard Excel formatting commands work.  For example,        
      objXL.worksheets(1).Columns(7).NumberFormat = "$#,##0"
works fine for formatting a column to currency.

I can't seem to get the gridlines to turn off.  The standard Excel command is
    ActiveWindow.DisplayGridlines = False
Which returns the error: "Object variable or WIth block variable not set"

I've tried a few different iterations:
   objXL.worksheets(1).DisplayGridlines = False
   objXL.worksheets(1).ActiveWindow.DisplayGridlines = False
but none of them worked.

Any help would be greatly appreciated.

Thanks!
MikeMc

   

Hide Gridlines in Excel Object on Access form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.