Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protected worksheet | Excel Discussion (Misc queries) | |||
Protected worksheet | Excel Discussion (Misc queries) | |||
Protected worksheet | Excel Discussion (Misc queries) | |||
Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
Protected Worksheet | New Users to Excel |