Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Shared Workbook - Freeze Pane & Hidden Column Issues
I've been searching the postings this morning to find some solutions, and I
am stuck. Hoping you can help. I have a shared workbook that is used by about 10 people. When users open the workbook there is some variation in how it is displayed. Problems occur in two areas: 1. The first row of the worksheet should be frozen, but sometimes much more is frozen when opened. I found "tools", "protection", "protect workbook", "windows", but that is acting strange... it opens with only about 5 columns visible and just the first row. What am I missing here? 2. There are several hidden columns in the workbook on multiple worksheets. When opened for some users the columns are not hidden. What can I do to be sure those columns are hidden? There are other problems with the shared workbook that I need to tackle, but these are the most troublesome. Any information/suggestions you can provide would be appreciated. Also, if you have any other "best practices" for shared workbooks please let me know what you recommend. Thanks so much, Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pane row and column freeze | Excel Discussion (Misc queries) | |||
How can I print the column headers in a freeze pane on all pag | Excel Discussion (Misc queries) | |||
Comments in freeze pane column | Excel Discussion (Misc queries) | |||
In Excel allow freeze pane in any column plus any row | Excel Worksheet Functions | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |