Annoying Error

K

Ken

Hi all,

I've developed a largish workbook using excel 97. It makes extensive use of
data validation in conjunction with Vlookups. It accessed as either
read-only or to write (for those with the password).

The way a part of it works is that when a particular screen is accessed (via
macro from the main page and directed to a specific cell), and a name is
selected from a dynamic validation range, other information is 'written' to
the screen via vlookups. To return to the main screen, another button
(macro) is selected which uses Range("A1").Select, then returns to Sheet
("Menu").Select then Range("C3").Select. So far so good.

If I then return to the other screen, the drop down gadget for data
validation still shows (even though the macro 'says' to select a different
cell). If the user selects this 'gadget' to select a name, then Excel
crashes. If I select the cell first, then the 'gadget' it works fine.

The spreadsheet is accessed by LAN and can have up to 65 simultaneous users,
although of course, only one will have write access at a time. At present
there are only 4-5 people using it. One person reports that it seems to work
fine when opened for read-only.

I am unable to reproduce this on own computer AMD900 512Mb XL2000, Win98SE
The error only seems to occur on ALL work computers, which are generally P4
1.6GHz, 256Mb, XL97, Win98.

I apologise for the term gadget but I don't know the correct term.

Thanks in advance for any help,

Ken

PS I accidently posted this to the programming group as well. Apologies for
this error
 

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

Top