Lock Page Breaks?

Is it possible to lock/protect page breaks on an excel sheet (Excel 2010)?
Thanks

Care to elaborate?

What to you want to achieve? What presents instead? Describe the desired outcome and then tell us about what's not working as expected.

I want to protect the page borders on a sheet. For example row 1 has important branding that must be included in print outs. I want to be able to lock them so someone else using the template cant delete row A by just pulling down the page break by 1 row and then pressing print so the branding does not appear in the print out sheet. Thanks

Why don't you just use sheet protection to prevent changes you don't want the user to make?

Select the cells that you want the users to edit, then format the selection and on the Protection tab untick the Locked box. Then click Review ribbon > Protect. You can set a password, so only people who enter the correct password can unprotect the sheet and change the locked cells.

But even when you protect a sheet and lock cells or even rows, another user can move the page break border and thus remove the cells from a printed copy.

Set the row as the print title that will be repeated on each page.

?? I don't understand. How do you mean set the print title? Thanks

You can designate one or more specific rows of the spreadsheet to appear at the top of each printed page. To do this, click the Page layout ribbon > Print titles > click the cell selector icon next to the the box for "rows to repeat at the top" and then select the row you want to show at the top of every page.

Tried it. It can still be changed by someone after the sheet has been protected and the rows have been locked bu just clicking on Print titles and deleting the selection. So cant protect it. Any other solutions?

Hi,

you can use a macro to set the print titles in a Workbook Before Print event. Every time a sheet is printed, it will run this macro first, which will re-instate the first row of the sheet as the print title.

Please Login or Register  to view this content.

Copy the code. In your workbook hit Alt-F11 to open the VB Editor, double click ThisWorkbook in the left hand navigation pane and past the code into the code window. Save the file as a macro-enabled file. To prevent changes to the VBA code, protect the code project with a password: In the VBE, right-click the VBA Project name of the file > VBA Project Properties > Protection Tab > Enter a password

regards,

OK. Thanks