Protected worksheet
I want to have my speadsheet be viewed ONLY as normal, and NOT as a page
break. How do I set that protection, that a student will not be able to even choose page break? I am using the spreadsheet online in a testing format. |
Protected worksheet
baseballmm wrote...
I want to have my speadsheet be viewed ONLY as normal, and NOT as a page break. How do I set that protection, that a student will not be able to even choose page break? I am using the spreadsheet online in a testing format. Excel provides no means of preventing users from viewing any visible worksheet in page break preview mode. If you controlled the machines that would be displaying the workbook, you could disable the menu item View Page Break Preview. If not, there's no way to prevent users from selecting this mode (because you can't modify their View menu), and selecting this mode triggers no event that you could monitor. Simply put, you can't do this in Excel. |
All times are GMT +1. The time now is 09:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com