ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Ex03 Custom views don't work (https://www.excelbanter.com/excel-programming/322271-ex03-custom-views-dont-work.html)

Paul

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


All times are GMT +1. The time now is 11:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com