Dear all,

I created a check box on the sheet1. I want to use this check box t
control
the Global boolean variable IsHideAllSheets. How can I program t
realize this
function? It seems a little difficult than a single button. Thanks.

Regards,

Davi

--
yangy
-----------------------------------------------------------------------
yangyh's Profile: http://www.excelforum.com/member.php...fo&userid=2688
View this thread: http://www.excelforum.com/showthread.php?threadid=46726

I'd use the checkboxes from the Forms toolbar.
Searching the old threads and found the following information. The
check box
works perfect in my program. Thank you Dave Peterson!!!

================================================== ====

Just add a checkbox to the worksheet.
rightclick on it and choose Format Control
on the Control tab, assign a nice linked cell
(Maybe column A of the row that holds the checkbox???)

Then this linked cell will be true or false depending on the
"checkedness" of
that checkbox.

If you have to have yes/no, you could use a formula in column B (same
row) that
looks like:

=if(a1=true,"yes","no")

And if you find that column A makes the worksheet look ugly, you could
always
hide it when you're done creating the worksheet.


--
yangyh
------------------------------------------------------------------------
yangyh's Profile: http://www.excelforum.com/member.php...o&userid=26883
View this thread: http://www.excelforum.com/showthread...hreadid=467265

Glad you found something useful!

yangyh wrote:

I'd use the checkboxes from the Forms toolbar.
Searching the old threads and found the following information. The
check box
works perfect in my program. Thank you Dave Peterson!!!

================================================== ====

Just add a checkbox to the worksheet.
rightclick on it and choose Format Control
on the Control tab, assign a nice linked cell
(Maybe column A of the row that holds the checkbox???)

Then this linked cell will be true or false depending on the
"checkedness" of
that checkbox.

If you have to have yes/no, you could use a formula in column B (same
row) that
looks like:

=if(a1=true,"yes","no")

And if you find that column A makes the worksheet look ugly, you could
always
hide it when you're done creating the worksheet.

--
yangyh
------------------------------------------------------------------------
yangyh's Profile: http://www.excelforum.com/member.php...o&userid=26883
View this thread: http://www.excelforum.com/showthread...hreadid=467265

--

Dave Peterson