| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why No Work?
I've been toying with thing the past 20 minutes
And it is refusing to work, any observations? Private Sub Workbook_BeforePrint(Cancel As Boolean) Application.EnableEvents = False Sheets("Sheet1").Range("C13").Font.ColorIndex = 2 Sheets("Sheet1").Range("C18").Font.ColorIndex = 2 ActiveSheet.PrintPreview Sheets("Sheet1").Range("C13").Font.ColorIndex = 1 Sheets("Sheet1").Range("C18").Font.ColorIndex = 1 Cancel = True Application.EnableEvents = True End Sub Intention, obviously is to hide (from printing) cells C13 and C18. TIA, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to update a column in a work based on another work sheet | New Users to Excel | |||
| how can i automatically generate work order numbers from work orde | Excel Discussion (Misc queries) | |||
| flash object dont work in my excel work sheet | Excel Discussion (Misc queries) | |||
| Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
| Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
Threaded Mode
