Cannot address a hidden sheet in my macro

Feb 28th, 2002, 08:49 AM

I`m building a macro in which I refer to a hidden sheet. If the sheet is unhidden everything works fine but if I hide the sheet I get an error! Has anyone ever stumbled accross this problem and does anyone know a solution?

thnks!

Remi,
Holland.

NateO · Feb 28th, 2002, 08:57 AM

You could unhide the sheet early in your procedure:

Sheets("Sheet1").Visible = True

Then hide the sheet at the end

Sheets("Sheet1").Visible = False

Cheers, Nate

Feb 28th, 2002, 09:28 AM

So I can set the sheet to hidden as default and hide and unhide it in my macro?

Gonne try right away!

Cheers!

Feb 28th, 2002, 09:49 AM

Yes it works...
GREAT

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 28th, 2002, 08:49 AM	#1
Guest Posts: n/a	I`m building a macro in which I refer to a hidden sheet. If the sheet is unhidden everything works fine but if I hide the sheet I get an error! Has anyone ever stumbled accross this problem and does anyone know a solution? thnks! Remi, Holland.

Feb 28th, 2002, 08:57 AM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	You could unhide the sheet early in your procedure: Sheets("Sheet1").Visible = True Then hide the sheet at the end Sheets("Sheet1").Visible = False Cheers, Nate

Feb 28th, 2002, 09:28 AM	#3
Guest Posts: n/a	So I can set the sheet to hidden as default and hide and unhide it in my macro? Gonne try right away! Cheers!

Feb 28th, 2002, 09:49 AM	#4
Guest Posts: n/a	Yes it works... GREAT