Workbook protection issue

[hebel53559]

Excel 2007. I have the workbook structure protected with a password. When I open the file, the worksheets are sized to file the normal Excel window space. When I email the spreadsheet to a customer who also has Excel 2007, the worksheets are small and she has to use the arrows to navigate. We tried changing her view and that didn't work. She does not have the arrows available to resize the window. The only way I could fix it for her was to remove the workbook structure protection. I'm nervous about leaving it this way for our entire customer base as they could unhide hidden sheets and even delete them. Has anyone else experienced this? One more thing, customers that have an earlier version of Excel have not had this problem. This workbook is save as an .xls to be backward compatible. Thanks.

 

[hebel53559]

According to the following information, by not protecting window structure, users will be able to resize the window and hide and unhide sheets.

Here is a link to the details of this part of Excel. http://office.microsoft.com/en-us/excel/HP052388541033.aspx

Here is the text of that link:
<TABLE><TBODY><TR><TD>Structure</TD><TD>

• Viewing worksheets that you have hidden.
• Moving, deleting, hiding, or changing the names of worksheets.
• Inserting new worksheets or chart sheets. (However, users can add embedded charts to existing worksheets by running the Chart Wizard.)
• Moving or copying worksheets to another workbook.
• In PivotTable reports, displaying the source data for a cell in the data area, or displaying page field (page field: A field that's assigned to a page orientation in a PivotTable or PivotChart report. You can either display a summary of all items in a page field, or display one item at a time, which filters out the data for all other items.) pages on separate worksheets.
• For scenarios, creating a scenario summary report.
• In the Analysis ToolPak, using the analysis tools that place results on a new worksheet.
• Recording new macros.

Note If you run a macro that includes an operation that can't be performed in a protected workbook, a message appears and the macro stops running.
</TD></TR><TR><TD>Windows</TD><TD>

• Changing the size and position of the windows for the workbook when the workbook is opened.
• Moving, resizing, or closing the windows. (However, users can hide and unhide windows.)

</TD></TR></TBODY></TABLE>
Note In the Visual Basic Editor (Visual Basic Editor: An environment in which you write new and edit existing Visual Basic for Applications code and procedures. The Visual Basic Editor contains a complete debugging toolset for finding syntax, run-time, and logic problems in your code.), programmers can protect macros so that the macros cannot be viewed or changed by users. Programmers can protect macros by using the Protection tab of the Project Properties dialog box in the Visual Basic Editor (Tools menu, Project Properties command). For more information, see Visual Basic Help (Microsoft Visual Basic Help: To get help for Visual Basic in Excel, point to Macro on the Tools menu, and then click Visual Basic Editor. On the Help menu, click Microsoft Visual Basic Help.).
To hide an entire workbook so that users cannot see it but can gain access to contents such as macros (macro: An action or a set of actions you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language.), use the Hide command on the Window menu, and then save the hidden workbook.

 

[Patof_007]

Thanks, so I'm understanding that protecting the workbook by checking the window case cause some problems and it not really that important.

Thanks guyz