Data Validation Failure Excel 2007

D

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hide column based on data validation 0
hide multiple worksheets based on a formula value in one cell 1
Data Validation Lost After Clearing All Shapes 3
Data Validation circle cell position 1
Data Validation 1
Worksheet change to control worksheet visibility 4
Validation list functionality disappered 4
Workbook_BeforeSave 8

Top