ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   remove sheet2 gray out (https://www.excelbanter.com/excel-programming/401522-remove-sheet2-gray-out.html)

John Smith

remove sheet2 gray out
 
In my VBAProject, there are ThisWorkbook, Sheet1(Sheet1) and
Sheet2(Sheet2). When I right click on Sheet2(sheet2), the "remove
sheet2 option is gray out. Does that mean the sheet is protected?

Also, how do I make the sheet visible? No sheet is visible in
Excel window. Thanks.

Gary Keramidas

remove sheet2 gray out
 
select the sheet in the project explorer window.
click view then properties or press F4.
at the bottom, verify the visible property.

--


Gary


"John Smith" wrote in message
...
In my VBAProject, there are ThisWorkbook, Sheet1(Sheet1) and
Sheet2(Sheet2). When I right click on Sheet2(sheet2), the "remove
sheet2 option is gray out. Does that mean the sheet is protected?

Also, how do I make the sheet visible? No sheet is visible in
Excel window. Thanks.





All times are GMT +1. The time now is 07:38 AM.

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