Sheet Visibility not working for xvExcel97 version
Posted: Wed Mar 08, 2017 10:08 am
Hi,
When I try to hide sheets on the old XLS format, it is still visible in the workbook when I view it. Visibility only seems to work for XLSX format.
Regards,
Carl
When I try to hide sheets on the old XLS format, it is still visible in the workbook when I view it. Visibility only seems to work for XLSX format.
Code: Select all
XLS.Version := xvExcel97;
Sheet := XLS.Add;
Sheet.Visibility := x12vVeryHidden; //I also tried x12vHidden.
XLS.SaveToFile('Test.xls');
Carl