Brenda

As I pointed out to you once before,,,,,,,,,,,,,this is VBA code, not
"formulas".

1. My response yesterday states.................

"Either of these placed in Thisworkbook module."

Remove the code from the sheet module.

Right-click on the Excel Icon left of "File" on the menu bar and "View
Code".

That opens Thisworkbook module.

Place either of the events in that module. Either will do the same
thing.........hide all sheets but the one.

2. Yes, but edit the sheet name first.

3. Replace "keep visible" with your actual sheet name.


Gord

On Fri, 7 Nov 2008 05:26:02 -0800, Brenda
wrote:

Gord, thank you for your response. I have just a couple of questions
1. I went with the first formula you supplied and went to the tab that i
want to keep open and right clicked to view code and entered the code there.
Does it matter where the code it placed?
2. After entering the code do i just hit save and close out and try to
reopen this should work right?
3. Last question, do I need to replace any of the wording you gave me with
my sheet names? Not sure how the program knows which sheets to keep hidden.
Not very good with this formula thing. Much appreciated...Brenda