I have created a report in excel that summarises data from 10 different
sheets. Each one of the sheets represents a different department.

I have created userforms for each department so that the data entry is
clean and automated but this has lead to a workbook with 12 sheets in
it.

I would like to have all of the data enrty sheets hidden but the data
entry macro I have written will nto enter the data into hidden sheets.

Is it possible to do so?




--
Pedros
------------------------------------------------------------------------
Pedros's Profile: http://www.excelforum.com/member.php...o&userid=28202
View this thread: http://www.excelforum.com/showthread...hreadid=572056

You cannot select hidden sheets, however you can write values to them:
Sheets("Sheet1").Visible = 2 'VeryHidden
Sheets("Sheet1").Range("A1") = "Hello"
MsgBox Sheets("Sheet1").Range("A1")

Charles

Pedros wrote:
I have created a report in excel that summarises data from 10 different
sheets. Each one of the sheets represents a different department.

I have created userforms for each department so that the data entry is
clean and automated but this has lead to a workbook with 12 sheets in
it.

I would like to have all of the data enrty sheets hidden but the data
entry macro I have written will nto enter the data into hidden sheets.

Is it possible to do so?




--
Pedros
------------------------------------------------------------------------
Pedros's Profile: http://www.excelforum.com/member.php...o&userid=28202
View this thread: http://www.excelforum.com/showthread...hreadid=572056

thanks, much appreciated!!


--
Pedros
------------------------------------------------------------------------
Pedros's Profile: http://www.excelforum.com/member.php...o&userid=28202
View this thread: http://www.excelforum.com/showthread...hreadid=572056