LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 71
Default Display Headings???

Hello Everyone,

I have created a makemenubar program that sets my own menu bar. Included in
it as below, I also formatted the workbook to turn everything off to clean
up the program and not allow them to edit it. Everything works, except 1
little glitch with the DisplayHeadings. Initially, when it defaults to my
startup page, I don't see the headings (A,B,C, 1,2,3 and so on. But, when I
click on a menu item and it takes me to another sheet, then the Headings pop
up in View??? Everything else stays FALSE except the Headings??? Is there
anyway to keep them turned OFF????

Application.DisplayStatusBar = False
Application.DisplayCommentIndicator = 0
Application.DisplayFormulaBar = False
Application.CommandBars("Formatting").Visible = False
Application.CommandBars("Standard").Visible = False
ActiveWindow.DisplayHeadings = False
ActiveWindow.DisplayGridlines = False
ActiveWindow.DisplayWorkbookTabs = False


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Office 2007 Pivot Table Display format - Show row headings in each Geoff B Excel Discussion (Misc queries) 1 September 29th 09 11:07 AM
Column headings display as a numbers Cynthia Excel Discussion (Misc queries) 7 August 20th 09 08:04 PM
Worksheet has numeric column headings. Change to alpha headings? Be Frank Excel Discussion (Misc queries) 1 June 18th 08 04:22 PM
How do I display an excel wrksht without column headings (A,B,C)? Fitzy Excel Discussion (Misc queries) 2 July 27th 06 04:25 AM
column headings display as numbers JayT Setting up and Configuration of Excel 2 November 29th 04 06:51 PM


All times are GMT +1. The time now is 07:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"