<div>
That is the way it works, I'm afraid, and there is no way round it other than not using one or the other, or programming the views you want in code.
</div>


That is the way it works, I'm afraid, and there is no way round it other than not using one or the other, or programming the views you want in code.

<div>
PS See the note about half way down this page: <a href="http://office.microsoft.com/en-us/excel-help/create-apply-or-delete-a-custom-view-HP001217045.aspx" rel="ugc">http://office.microsoft.com/en-us/excel-help/create-apply-or-delete-a-custom-view-HP001217045.aspx</a>
</div>


PS See the note about half way down this page: http://office.microsoft.com/en-us/excel-help/create-apply-or-delete-a-custom-view-HP001217045.aspx [http://office.microsoft.com/en-us/excel-help/create-apply-or-delete-a-custom-view-HP001217045.aspx]

<div>
Hi Roya,<br />
So, can you advise how to apply custom views through VBA code? &nbsp;All I aim for is hiding columns through the custom views.<br />
Thanks,<br />
sinkerballer
</div>


Hi Roya,
So, can you advise how to apply custom views through VBA code?  All I aim for is hiding columns through the custom views.
Thanks,
sinkerballer

<div>
Thanks for the information and instruction. :)
</div>


Thanks for the information and instruction. :)

<div>
<div class="content wysiwyg-content">
I am using Excel 2007 in a macro-enabled workbook and using formatted table, which bands the rows and auto-expands the table with added rows.<br />
I wish to use multiple custom views, but the feature is greyed out and not available in this file.<br />
Even saving the file as standard xlsx did not restore the custom views.<br />
<br />
Thanks,<br />
sinkerballer
</div>
</div>


I am using Excel 2007 in a macro-enabled workbook and using formatted table, which bands the rows and auto-expands the table with added rows.
I wish to use multiple custom views, but the feature is greyed out and not available in this file.
Even saving the file as standard xlsx did not restore the custom views.

Thanks,
sinkerballer

Excel: why can't I use Custom Views in xlsm with Formatted Tables?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.