Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
break page
Hi,
I have another problem,example the word 'signature' is always in the same column but it changes row. I wont to do a break page in the same row when the word 'signature' arise! End last question is...how can I lock view code,that no one can use it! Thanks in advance! Mery |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
break page
This code will insert a pagebreak below the word Signature in column A
Sub Insert_PBreak() Dim OldVal As String Dim rng As Range OldVal = "Signature" For Each rng In Range("A1:A300") '<< change range If rng.text = OldVal Then rng.Offset(1, 0).PageBreak = xlPageBreakManual End If Next rng End Sub Second problem.................. Open the VBE. Select your workbook/project and right-clickmyworkbook propertiesprotectionlock project for viewing. Add a password and OK out. Note: file must be saved, closed and re-opened before protection takes place. Gord Dibben MS Excel MVP On Sun, 6 Apr 2008 09:02:00 -0700, Mery wrote: Hi, I have another problem,example the word 'signature' is always in the same column but it changes row. I wont to do a break page in the same row when the word 'signature' arise! End last question is...how can I lock view code,that no one can use it! Thanks in advance! Mery |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
break page
Thank you very much,it was very useful!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Page Break Adjustments causes a page break each cell | Excel Worksheet Functions | |||
How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
change and/or remove page number watermark in page break preview | Excel Discussion (Misc queries) | |||
Hiding the page number in page break preview background. | Excel Discussion (Misc queries) | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) |