![]() |
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