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?

--
Email address is not valid.
Please reply to newsgroup only.

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
--
Email address is not valid.
Please reply to newsgroup only.


"Dale Fye" wrote:

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?

--
Email address is not valid.
Please reply to newsgroup only.

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

Dale Fye wrote:

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
--
Email address is not valid.
Please reply to newsgroup only.

"Dale Fye" wrote:

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?

--
Email address is not valid.
Please reply to newsgroup only.

--

Dave Peterson

Thanks,

I'm finally getting the hang of this.

Dale
--
Email address is not valid.
Please reply to newsgroup only.


"Dave Peterson" wrote:

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

Dale Fye wrote:

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
--
Email address is not valid.
Please reply to newsgroup only.

"Dale Fye" wrote:

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?

--
Email address is not valid.
Please reply to newsgroup only.

--

Dave Peterson