Data Validation Failure Excel 2007

[david_bn]

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!

 

[Ron de Bruin]

I have test it and not have a problem David.