View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chrissy[_4_] Chrissy[_4_] is offline
external usenet poster
 
Posts: 101
Default Inconsistant Macro Behoviour

I have developed an Excel spreadsheet which I want to run
on 15 different computers.

I developed it in Excel 2002 and Excel 2000 - depending one
which machine I was at. It is to run on Excel 2000. I cannot
make it fail in any way on my computer but it does on all other
computers I have tried it on now.

My setup is:

Win2k Professional
Office XP Professional installed then
Excel from Office 2k professional installed separately then,
because Office XP stopped working
Office XP Professional reinstalled

Their setup

Win98
Office2k Professional

I have a couple of forms and 10 worksheets. I have protected the
project from viewing and the worksheets are all password protected.

There is a button on the first spreadsheet which opens up the main form.
This causes a page fault in Excel and Excel then closes. The computer
needs rebooting at this stage so the workbook can be reopened as it will
get a sharing problem if just opened without a reboot. The computer is
not networked.

If I remove the protection from the project it works on one machine
but not on one other. If I run it on my machine even after a reboot
and without entering any passwords it runs fine. I run it under Excel2k
and not Excel XP.

Am I correct in thinking that I must be using different DLLs to the other
machines? What can I do to get this working?

Any help or suggestions are more than welcome.

TIA.

Chrissy.