MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Deleting CUSTOM REPORT VIEWS thru VBA.


Posted by bill on October 24, 2001 6:43 AM

Anyone know how to delete the above as described?

Thanks...


Posted by George Camsell on October 24, 2001 7:09 AM


I got this code by using the macro recorder :-

ActiveWorkbook.CustomViews("MyCustomView").Delete

Posted by bill on October 24, 2001 12:19 PM

Thanks George.

Yet, I tried looping through the CUSTOM VIEWS and found none.

It seems that CUSTOMVIEWS and REPORTVIEWS are diff.

I did forget about that blasted MACRO RECORDER and will see what happens if i create a REPORTVIEW.

Thanks for pushing me in the right direction:)