LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
saveas ActiveWorkbook.SaveAs Filename:=Range("A1").Value DarrenL Excel Programming 4 April 18th 09 07:54 AM
Excel SaveAs not using specified FileFormat NancyTG Excel Programming 2 February 22nd 07 11:27 PM
locking formula in cells in without locking whole sheet SuziQ Excel Discussion (Misc queries) 1 July 21st 06 03:58 PM
macro to savecopy as and break links schoolie Excel Programming 1 May 22nd 06 09:06 AM
Append DateTime to Fiename, saveCopy CLR Excel Programming 2 April 17th 06 03:43 PM


All times are GMT +1. The time now is 10:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"