I have a particular xlsm file in Excel V 10 that is greyed out and dcannot
find how to unlock this feature. Feature OK in new files. Any Ideas?

Let me clarify the problem. "Custom Views" is greyed out in the "View"
ribbon on only this file and I cannot find out how to reset
it!..................Mervyn
"Mervyn Thomas" <mervyn-(E-Mail Removed)> wrote in message
news:QqCeq.6$(E-Mail Removed)2...
>I have a particular xlsm file in Excel V 10 that is greyed out and dcannot
>find how to unlock this feature. Feature OK in new files. Any Ideas?
>
>

"Mervyn Thomas" <mervyn-(E-Mail Removed)> wrote in message
news:dgDeq.11616$(E-Mail Removed)2...
> Let me clarify the problem. "Custom Views" is greyed out in the
> "View" ribbon on only this file and I cannot find out how to reset
> it!..................Mervyn
> "Mervyn Thomas" <mervyn-(E-Mail Removed)> wrote in message
> news:QqCeq.6$(E-Mail Removed)2...
>>I have a particular xlsm file in Excel V 10 that is greyed out and
>>dcannot find how to unlock this feature. Feature OK in new files.
>>Any Ideas?
>>
>>
>
>


Worksheet or Workbook protection?

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)

More than one sheet selected?


Gord Dibben Microsoft Excel MVP

On Thu, 22 Sep 2011 10:00:51 +0100, "Mervyn Thomas"
<mervyn-(E-Mail Removed)> wrote:

>Let me clarify the problem. "Custom Views" is greyed out in the "View"
>ribbon on only this file and I cannot find out how to reset
>it!..................Mervyn
>"Mervyn Thomas" <mervyn-(E-Mail Removed)> wrote in message
>news:QqCeq.6$(E-Mail Removed)2...
>>I have a particular xlsm file in Excel V 10 that is greyed out and dcannot
>>find how to unlock this feature. Feature OK in new files. Any Ideas?
>>
>>
>

I have found that as soon as I put on the worksheet page a Microsoft Query
to an ODBC driven Sage database then the custom view gets greyed out. I
have got around the problem by having macro driven print settings which is
why I wanted the custome views anyway.......,,,,Mervyn
"Gord" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> More than one sheet selected?
>
>
> Gord Dibben Microsoft Excel MVP
>
> On Thu, 22 Sep 2011 10:00:51 +0100, "Mervyn Thomas"
> <mervyn-(E-Mail Removed)> wrote:
>
>>Let me clarify the problem. "Custom Views" is greyed out in the "View"
>>ribbon on only this file and I cannot find out how to reset
>>it!..................Mervyn
>>"Mervyn Thomas" <mervyn-(E-Mail Removed)> wrote in message
>>news:QqCeq.6$(E-Mail Removed)2...
>>>I have a particular xlsm file in Excel V 10 that is greyed out and
>>>dcannot
>>>find how to unlock this feature. Feature OK in new files. Any Ideas?
>>>
>>>
>>
>

Thanks for the update on your cause and fix.


Gord

On Thu, 22 Sep 2011 17:38:12 +0100, "Mervyn Thomas"
<mervyn-(E-Mail Removed)> wrote:

>I have found that as soon as I put on the worksheet page a Microsoft Query
>to an ODBC driven Sage database then the custom view gets greyed out. I
>have got around the problem by having macro driven print settings which is
>why I wanted the custome views anyway.......,,,,Mervyn
>"Gord" <(E-Mail Removed)> wrote in message
>news:(E-Mail Removed)...
>> More than one sheet selected?
>>
>>
>> Gord Dibben Microsoft Excel MVP
>>
>> On Thu, 22 Sep 2011 10:00:51 +0100, "Mervyn Thomas"
>> <mervyn-(E-Mail Removed)> wrote:
>>
>>>Let me clarify the problem. "Custom Views" is greyed out in the "View"
>>>ribbon on only this file and I cannot find out how to reset
>>>it!..................Mervyn
>>>"Mervyn Thomas" <mervyn-(E-Mail Removed)> wrote in message
>>>news:QqCeq.6$(E-Mail Removed)2...
>>>>I have a particular xlsm file in Excel V 10 that is greyed out and
>>>>dcannot
>>>>find how to unlock this feature. Feature OK in new files. Any Ideas?
>>>>
>>>>
>>>
>>
>