remove sheet2 gray out

  • Thread starter Thread starter John Smith
  • Start date Start date
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.
 
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

How to activate Sheet2? 5
My Never ending ARRAY code problems 18
Merging 2 sheets. 1
Sheet to sheet code Type Mismatch 6
Match using VBA 4
range name define on non active(focused) sheet 10
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Resize to last entry in row and copy to sheet 1 3

Back
Top