remove sheet2 gray out

J

John Smith

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.
 
G

Gary Keramidas

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
How to activate Sheet2? 5
Macro beginner help with making tables 1
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
modified pivot table using a macro 2
range name define on non active(focused) sheet 10
Select Case Code does not run... 10
Copy .Areas.Item(1,2,3,4,5, etc.) to a column or a row 5

Top