View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Paul is offline
external usenet poster
 
Posts: 661
Default Ex03 Custom views don't work

Hi all.
I'm running WXPProSP2, and Ex03. When I try to show a custom view 2 things
happen- 1. I get an exclamation message box with the prompt "Some view
settings could not be applied". 2. The custom view I want doesn't show.

I have a feeling the Workbook/worksheet protection is somehow involved, but
I unprotect everything before I create the view, and also when I try to show
the view. Also, the WB has macros from Excel4 that used the views add-in,
but I've remmed these out; and the reference for the views.xla is not
checked. (This WB has been around for a decade now, and this current project
is to bring up to the 21 century)

The only workaround I can think of is to code in the view using VBA, but
this would be unnecessary, if I could get the views to work.

Any ideas are welcomed, and thank you for looking at my posting,
Paul