Page 1 of 1

Delete method of Worksheet class failed

Posted: Mon Aug 28, 2017 1:04 pm
by gtonkin
Had a template that I needed to run TM1 Print Report on, but kept failing with "Print Report-Delete method of Worksheet class failed" - turned out to be a sheet that was flagged as Visible:=2-xlSheetVeryHidden.

Changed to visible and deleted in my case-all fine now.
Seemed fine if set to 0-xlSheetHidden but Print Report does not like xlSheetVeryHidden.

Re: Delete method of Worksheet class failed

Posted: Tue Feb 12, 2019 12:50 am
by ngphong
Thank you so much for this postings. It's very helpful. It worked for me when I changed the Visible to "0-xlSheetHidden" on the "Cognos_Office_Connection_Cache" which was not visible. It only shows on the VBA window of Developer menu.