Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
hiding the headers
Hi,
I'm having a problem with the headings in excel. I've done calculation program and I'd like to give non-excel looking look to it Everething is ok until I print a sheet from it, after that the heading are visible again... I've tried to hide those after printing on macr like this: For s = 23 To ActiveWorkbook.Sheets.Count Sheets(s).Activate ActiveWindow.DisplayGridlines = False ActiveWindow.DisplayHeadings = False ActiveWindow.DisplayHorizontalScrollBar = False ActiveWindow.DisplayVerticalScrollBar = False ActiveWindow.DisplayWorkbookTabs = False Next s Sheets(1).Activate The same marco is in the workbook open sub and there is also simila proble, the macro don't hide headings if the workbook is saved heading unhidden. I hope that someone can help me... Regards Wilb -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
hiding the headers
Different options for print as you may have guessed:
File, Page Setup, Sheet (tab), turn off row and column headings The options for Display don't affect printing: Tools, Options, View (tab), row and column headings It didn't sound like you really wanted a macro: you would get these lines of code from recording a macro: With ActiveSheet.PageSetup .PrintTitleRows = "" .PrintTitleColumns = "" End With --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Wilbo " wrote in message news:Wilbo.181aum@excelforum- I'm having a problem with the headings in excel. I've done a calculation program and I'd like to give non-excel looking look to it. Everething is ok until I print a sheet from it, after that the headings are visible again... I've tried to hide those after printing on macro |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup using column headers and row headers | Excel Discussion (Misc queries) | |||
HEADERS | Excel Discussion (Misc queries) | |||
Hiding matrix headers | Setting up and Configuration of Excel | |||
Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
headers | Excel Programming |