Custom View settings

Topic

New Reply

Excel 2007 Windows XP sp3
Is it possible to view the settings for existing custom views in a workbook – and how?
either from ribbon or vba.

Thanks

Reply | Quote

Replies

Depends what you mean by settings. If you mean which rows and columns are hidden and what the print settings are, then no, other than actually switching to the view.

Reply | Quote

Thanks Rory, it was actually the definition of the custom view just as you say.
Once custom view is selected the workbook goes into long drawn out process of switching sheets and calculations run over and over again.
I was hoping that the settings as to which worksheet and which columns/rows/views would be set in order to try and check the steps one at a time.
Thanks for reply.
alan

Reply | Quote