View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anthony[_18_] Anthony[_18_] is offline
external usenet poster
 
Posts: 18
Default Savecopy and saveas locking up excel

Hi,

The project is running on Excel 2003. The work machines are locked down and
users don't have administration rights, so I cant look at permissions etc...

The error is limited to only a few, but all seem to be on HP laptops, but
not all HP laptops have the problem.

The code is basically

Workbook_open

make worksheets visible

application.displayalerts = false
thisworkbook.saveas thisworkbook.path &"\(backup) " &
thisworkbook.name
application.displayalerts = true

turn of menus
turn of sheet tabs
stop certain key combinations

make first page visible


This locks excel up. The user has to ctrl+alt+del to close it down.
if I remove the saveas it works.
The saveas line is exactly the same as the save option in the project once
its running, but that works without any problems (although there is a slight
pause)

If I replace saveas with savecopy function its exactly the same.


Anyone with any ideas?


Thanks in advance