Custom Views Problem

[Guest]

I'm hoping some one can help.
I have set up 3 custom views for displaying sections of my spreadsheet to
different users.

One of the views hides most of the rows on the worksheet. However, when I
select this view I get two error messages on the screen.
"Cannot shift objects off sheet" & "Some view settings could not be applied"
It is the hiding of the rows that is not applied.

Can anyone help on this?

 

[Guest]

Can you post the code that you are using at the moment?
It sounds like you are adding rows rather than hiding / unhiding them.

 

[Guest]

Hi Allllen

I didn't write any code, I just set the sheet up as I wanted it to look and
then used the Custom Views menu option.

I've ended up working round this by using macro recorder to create a macro
which does basically the same, but I would like to understand what these
errors are about for future use.

 

[Ragdyer]

Is your sheet protected?

Views doesn't work on protected sheets.