Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 82
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pane row and column freeze Dean475 Excel Discussion (Misc queries) 1 June 16th 09 08:38 PM
How can I print the column headers in a freeze pane on all pag Meenie Excel Discussion (Misc queries) 0 January 16th 07 08:14 PM
Comments in freeze pane column jimt Excel Discussion (Misc queries) 0 January 15th 07 08:49 PM
In Excel allow freeze pane in any column plus any row vlado Excel Worksheet Functions 1 October 11th 05 05:00 PM
Freeze Pane problem in shared workbooks JM Excel Discussion (Misc queries) 1 February 1st 05 12:04 AM


All times are GMT +1. The time now is 07:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"