+ Reply to Thread
Results 1 to 3 of 3

Hide Headings, Formula bar, Gridlines, etc on all workbook sheets

  1. #1
    Registered User
    Join Date
    02-06-2013
    Location
    nunya
    MS-Off Ver
    Excel 2010
    Posts
    9

    Hide Headings, Formula bar, Gridlines, etc on all workbook sheets

    I would like to hide the heading, gridlines, and tabs on the entire workbook. I currently can only hide these on the first activewindow that appears on workbook open. My current code is:
    Application.DisplayFormulaBar = False
    ActiveWindow.DisplayWorkbookTabs = False
    ActiveWindow.DisplayHeadings = False
    ActiveWindow.DisplayGridlines = False
    I had thought that simply replacing the activewindow with application would do the trick, but it does not. I would like this to occur on the initial workbook open event. Thanks in advance.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Hide Headings, Formula bar, Gridlines, etc on all workbook sheets

    Add this code in your Thisworkbook Open event.

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    02-06-2013
    Location
    nunya
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Hide Headings, Formula bar, Gridlines, etc on all workbook sheets

    That did not work properly. I received an application or object defined error message. I noticed you declared Worksheet in two variables. I think that may be causing the problem, but I am not sure. I realize that I can save the workbook with the show features selected in each worksheet and it generates the results that I desire, but I would like to ensure that this happens at the opening of the workbook every time.

+ 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