Hi,

Long time no post.

Have just opened in Excel 2007 a file created in Excel 2003 that has/
had a hidden sheet with named ranges used in Data Validation on non-
hidden sheets. Data validation no longer works, range name does not
appear in list as before, hidden sheets have GONE!!!. What have I gone
wrong?
(Used a simple count sheet function (below) that confirms the only
sheets are the visible ones.)

Sub test()
x = Worksheets.Count
MsgBox (x)
End Sub

Do I have to UNHIDE in the earlier version BEFORE I open in 2007?

Rather difficult now!

I have test it and not have a problem David.


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


<(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Hi,
>
> Long time no post.
>
> Have just opened in Excel 2007 a file created in Excel 2003 that has/
> had a hidden sheet with named ranges used in Data Validation on non-
> hidden sheets. Data validation no longer works, range name does not
> appear in list as before, hidden sheets have GONE!!!. What have I gone
> wrong?
> (Used a simple count sheet function (below) that confirms the only
> sheets are the visible ones.)
>
> Sub test()
> x = Worksheets.Count
> MsgBox (x)
> End Sub
>
> Do I have to UNHIDE in the earlier version BEFORE I open in 2007?
>
> Rather difficult now!
>