I have a porblem with shared woorkbook, created in excel 2002, that is
password protected.

when opened/run in excel 97 it crashes on the following code (which
programatically creates a sheet from another):

' Now recreate from an image of the template
Sheets("Template").Select
Sheets("Template").Copy after:=Sheets(1)
Sheets(2).Name = "Report"

Is there some sort of compatibility issue that causes the above code to
crash in 97 but not in 2002 ?

any input/advise would be very much appreciated.

thanks !!!!


--
sconly
------------------------------------------------------------------------
sconly's Profile: http://www.excelforum.com/member.php...o&userid=34038
View this thread: http://www.excelforum.com/showthread...hreadid=537995

there is not reason that particular code shouldn't work.

This is a guess, but
after the crash, go into the vbe into tools=references and see if any
references are marked as MISSING. If so, you need to fix that problem.

--
Regards,
Tom Ogilvy


"sconly" wrote:



I have a porblem with shared woorkbook, created in excel 2002, that is
password protected.

when opened/run in excel 97 it crashes on the following code (which
programatically creates a sheet from another):

' Now recreate from an image of the template
Sheets("Template").Select
Sheets("Template").Copy after:=Sheets(1)
Sheets(2).Name = "Report"

Is there some sort of compatibility issue that causes the above code to
crash in 97 but not in 2002 ?

any input/advise would be very much appreciated.

thanks !!!!


--
sconly
------------------------------------------------------------------------
sconly's Profile: http://www.excelforum.com/member.php...o&userid=34038
View this thread: http://www.excelforum.com/showthread...hreadid=537995