Hide a worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to be able to hide a worksheet that I am using for data storage, how
can I do this programmatically? Using the Excel menus?
 
figured it out activeworkbook.sheets(1).visible = false

Unfortunately, it appears that now that I have hidden that worksheet, I can
no longer refer to the cells on it? Any way to work around this?

Dale
 
You can still refer to the cells on that hidden sheet. But you won't be able to
select the sheet or select cells on that sheet.


with worksheets("Sheet999")
'hide the sheet
.visible = xlsheethidden
'do some stuff
.range("a1").value = "hi"
.range("z1").value = "There"
.cells(23,"x").clearcontents
'check it out
.visible = xlsheetvisible
end with
 
You must log in or register to reply here.

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

Open Specific Worksheet Using Button Form Control in Excel 0
Loop to hide sheet based on cell 1
Programmatically hide an object - Excel 2003 or 2007 1
To protect user's privacy 1
hide excel sheets 3
Hide menus etc in Excel 2007 5
Access Textbox - Hide Cursor 0
hide colum based on cell value on each worksheets 2

Back
Top