....between xlHidden and xlVeryHidden?

Curiously,

wazooli

Try manually unhiding each different type using format, sheet, unhide.


"Wazooli" wrote in message
...
...between xlHidden and xlVeryHidden?

Curiously,

wazooli

of course - makes perfect sense. thanks.

"Steve" wrote:


Try manually unhiding each different type using format, sheet, unhide.


"Wazooli" wrote in message
...
...between xlHidden and xlVeryHidden?

Curiously,

wazooli

Wazooli,

xlHidden will mean that the sheet is not visible in Excel, but can also be
made visible in Excel

xlVeryHidden will also mean that the sheet is not visible in Excel, but it
can only be made visible in VBA, Excel cannot do so

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Wazooli" wrote in message
...
...between xlHidden and xlVeryHidden?

Curiously,

wazooli

xlHidden is what happens when you hide a sheet manually using the menus.

xlVeryHidden can only be applied through code, and the sheet will not be
visible at all to the user if they try and unhide it from the menu. It can
only be made visible again through code.

Robin Hammond
www.enhanceddatasystems.com

"Wazooli" wrote in message
...
...between xlHidden and xlVeryHidden?

Curiously,

wazooli