Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 380
  • Last Modified:

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

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
0
sinkerballer
Asked:
sinkerballer
  • 3
  • 2
1 Solution
 
Rory ArchibaldCommented:
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.
0
 
Rory ArchibaldCommented:
0
 
sinkerballerAuthor Commented:
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
0
 
Rory ArchibaldCommented:
It's not custom views per se - you would need code to specifically hide the columns/rows you don't want - for example:
With Sheets("sheet1").range("a:c,e:e,I:k").entirecolumn
   .hidden = not .hidden
End with

would toggle showing or hiding the specified columns each time you run it.
0
 
sinkerballerAuthor Commented:
Thanks for the information and instruction. :)
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now