Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
saveas ActiveWorkbook.SaveAs Filename:=Range("A1").Value | Excel Programming | |||
Excel SaveAs not using specified FileFormat | Excel Programming | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
macro to savecopy as and break links | Excel Programming | |||
Append DateTime to Fiename, saveCopy | Excel Programming |