Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove Vpagebreak or move to end of sheet.
What I'm trying to do is set up a spread sheet that will print out to 1 page
wide and X long. I've already managed to set the orientation to landscape and I can add a VPageBreak where ever I need it but how do I remove the one that is automatically inserted by Excel 2003? Any help would be hot. Thanks. Chaz |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove Vpagebreak or move to end of sheet.
Well, I found my own answer to move VPageBreaks to the last column. I
recorded a macro as I went to the page break view and moved it that way. I was on the right track when I used the Dragoff method. I just needed to make sure I made the view change to page break view, moved the break, and then return to normal view. Since I used the Application.ScreenUpating=False, the User doesn't see the shift. Here is the code below. Application.ScreenUpdating=False ActiveWindow.View = xlPageBreakPreview ActiveSheet.VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1 ActiveWindow.View = xlNormalView Application.ScreenUpdating=True Hope this helps the rest of you out there. Chaz "MentalDrow" wrote: What I'm trying to do is set up a spread sheet that will print out to 1 page wide and X long. I've already managed to set the orientation to landscape and I can add a VPageBreak where ever I need it but how do I remove the one that is automatically inserted by Excel 2003? Any help would be hot. Thanks. Chaz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hpagebreak and vpagebreak | Excel Programming | |||
VPageBreak Problem | Excel Programming | |||
Hmmm... Excel OVERRIDES vpagebreak and hpagebreak vb code???? | Excel Programming | |||
Hmmm... Excel OVERRIDES vpagebreak and hpagebreak vb code???? | Excel Programming | |||
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming |