保护电子表格的格式
我正在创建一个费用报销电子表格，允许用户输入他们的支出，电子表格将自动添加所有列。我已保护电子表格，以便他们只能在未受保护的单元格中输入信息。我遇到的问题是：如何保护工作表，以便当有人打印表单时，他们无法更改打印布局？ （即他们不应该能够更改页面布局，或更改页边距等）。我如何保护电子表格不被某人打印在合法纸张上，或将其放在两页上等？
I am creating an Expense Reimbursement spreasheet that will allow users to input their expenditures and the spreadsheet will automatically add all of the columns. I have protected the spreadsheet so that they can only enter information in unprotected cells. The problem I am having is: how do I protect the sheet so that when someone prints the form, they cannot change the print layout? (i.e. they should not be able to change the page layout, or change the margins, etc.) How can I protect the spreadsheet from someone printing it on legal paper, or putting it on 2 pages, etc?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
据我所知，没有办法锁定布局......但是你用VBA怎么样？
Worksheets("SheetName").PageSetup对象将允许您指定所有页面设置属性，并且如果您要将这些规范放入工作簿的Workbook_BeforePrint和 < code>Workbook_BeforeSave 子例程，Excel 会在打印（和保存）之前“重置”您的规范，确保您的布局得到遵守。There is, far as I can tell, no way to lock the layout... But how are you with VBA?
The
Worksheets("SheetName").PageSetupobject will allow you to specify all of the page setup properties, and if you were to put these specifications in the Workbook'sWorkbook_BeforePrintandWorkbook_BeforeSavesubroutines, Excel would 'reset' your specifications right before it printed (and saved), ensuring that your layout was honoured.