ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Remove Sheet (https://www.excelbanter.com/excel-programming/414093-remove-sheet.html)

ranswrt

Remove Sheet
 
I am writing procedures that remove and add sheets to a workbook. As I have
been testing it one sheet that got deleted shows up on in the Project
Explorer window in Visual Basic. I checked the hidden worksheets in excel
and it doesn't show up there. How do I get rid of it?
Thanks

RyanH

Remove Sheet
 
Try deleting the sheet by name.
--
Cheers,
Ryan


"ranswrt" wrote:

I am writing procedures that remove and add sheets to a workbook. As I have
been testing it one sheet that got deleted shows up on in the Project
Explorer window in Visual Basic. I checked the hidden worksheets in excel
and it doesn't show up there. How do I get rid of it?
Thanks


ranswrt

Remove Sheet
 
Thanks

"RyanH" wrote:

Try deleting the sheet by name.
--
Cheers,
Ryan


"ranswrt" wrote:

I am writing procedures that remove and add sheets to a workbook. As I have
been testing it one sheet that got deleted shows up on in the Project
Explorer window in Visual Basic. I checked the hidden worksheets in excel
and it doesn't show up there. How do I get rid of it?
Thanks



All times are GMT +1. The time now is 12:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com