INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Jobs from Indeed

Programmaticlly changing Excel advanced options

Programmaticlly changing Excel advanced options

(OP)
I know that I can navigate to the display options from within an Excel file, but how do you access the advanced options programmatically?

I need to be able to clear the "Show a zero in cells that have zero value" property programmatically. But, I don't know where the Options | Advanced | Display options for this worksheet is located in the DOM.

Thanks in advance,
Jerry

Jerry Scannell

RE: Programmaticlly changing Excel advanced options

In Excel I created 2 Macros with the steps you described:
one - un-checking Display options for this worksheet, and
two - Checking Display options for this worksheet

CODE

Option Explicit
Sub Macro1()
    ActiveWindow.DisplayZeros = False
End Sub
Sub Macro2()
    ActiveWindow.DisplayZeros = True
End Sub 

Would that help?

Have fun.

---- Andy

There is a great need for a sarcasm font.

RE: Programmaticlly changing Excel advanced options

(OP)
Andy,

Thanks for that. In VBA you can use ActiveWindow. But where is the DisplayZeros property when you are accessing Excel objects from with in VB.net application?

Jeerry

Jerry Scannell

RE: Programmaticlly changing Excel advanced options

Some code from here, and:

CODE

Imports Excel = Microsoft.Office.Interop.Excel

Public Class Form1

    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Dim appXL As Excel.Application
        Dim wbXl As Excel.Workbook
        Dim shXL As Excel.Worksheet
        Dim raXL As Excel.Range
        ' Start Excel and get Application object.
        appXL = CreateObject("Excel.Application")
        appXL.Visible = True
        ' Add a new workbook.
        wbXl = appXL.Workbooks.Add

        appXL.ActiveWindow.DisplayZeros = False
    End Sub
End Class 

Hmmm, you are asking VB.NET question in C# Forum...

Have fun.

---- Andy

There is a great need for a sarcasm font.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close