xlsheethidden vs. xlsheetveryhidden

Rick M · May 24th, 2002, 07:59 AM

What is the difference between xlsheethidden vs. xlsheetveryhidden?

Ian Mac · May 24th, 2002, 08:04 AM

Quote:

On 2002-05-24 06:59, Rick M wrote:
What is the difference between xlsheethidden vs. xlsheetveryhidden?

xlsheetveryhidden is very hidden not just a little bit, very

xlsheetveryhidden can't be Unhidden from with Excel you have to unhide it from VBE.
Very handy if you need to hide data you don't want anyone to see even if they try to unhide from the Format>Sheet>Unhide, they just won't be able to se it.

Regards

_________________
Share the wealth!!
Ian Mac

[ This Message was edited by: Ian Mac on 2002-05-24 07:05 ]

[ This Message was edited by: Ian Mac on 2002-05-24 07:05 ]

Rick M · May 24th, 2002, 08:11 AM

Thanks....

ilya2004 · Oct 10th, 2011, 10:28 AM

Can VBA code interact with sheets that are xlveryhidden or do I have to unhide them first?

jonmo1 · Oct 10th, 2011, 10:31 AM

No, Sheets do not need to be visible to manipulate them.

As far as VBA is concerned, there is no difference between hidden and veryhidden.
The only real difference between the two is that veryhidden cannot be UNhidden from the Excel GUI.
Veryhidden can only be UNhidden from VBA.

ilya2004 · Oct 11th, 2011, 04:32 PM

Great, thank you!

Oct 10th, 2011, 10:28 AM	#4
ilya2004 Board Regular Join Date: Mar 2011 Posts: 86	Re: xlsheethidden vs. xlsheetveryhidden Can VBA code interact with sheets that are xlveryhidden or do I have to unhide them first? __________________ -Ilya V Webmaster KikiRiki Shells

Oct 10th, 2011, 10:31 AM	#5
jonmo1 MrExcel MVP Join Date: Oct 2006 Location: Bryan, TX Posts: 21,134	Re: xlsheethidden vs. xlsheetveryhidden No, Sheets do not need to be visible to manipulate them. As far as VBA is concerned, there is no difference between hidden and veryhidden. The only real difference between the two is that veryhidden cannot be UNhidden from the Excel GUI. Veryhidden can only be UNhidden from VBA. __________________ Want better/faster responses to your questions? Use Excel Jeanie to post samples of your sheet. The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious. Life moves pretty fast. If you don't stop and look around once in a while, you could miss it. Ferris Bueller A.K.A. John Hughes, 1986

Oct 11th, 2011, 04:32 PM	#6
ilya2004 Board Regular Join Date: Mar 2011 Posts: 86	Re: xlsheethidden vs. xlsheetveryhidden Great, thank you! __________________ -Ilya V Webmaster KikiRiki Shells

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

May 24th, 2002, 07:59 AM	#1
Rick M New Member Join Date: Feb 2002 Location: Tampa, Fla Posts: 44	What is the difference between xlsheethidden vs. xlsheetveryhidden?

May 24th, 2002, 08:11 AM	#3
Rick M New Member Join Date: Feb 2002 Location: Tampa, Fla Posts: 44	Thanks....