I have a shared workbook with autofilter and frozen panes and the "freeze"
moves around when the filter is used by users (it seems to move with the
filters). Although protecting the windows of the workbook solves the
problem, the format of the protected workbook is really not user friendly.
Kind of a small minimized window that you can't maximize and move around.
Because the settings of the users as well as the size of their monitor are
all different, sometimes it's impossible to see the tabs and there is no
horizontal scrolling bar. Basically solving one problem causes another. Is
there a way to solve one without causing the other?
Thanks
Sandra