Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible bug?
Hi I got Excell 2000 I have a piece of code which opens a workbook(a) and copys selecte sheets to Workbook(B). I then close workbook (A) but do not want th "do you want to save..." display to pop up so I wrote the followin code to stop it from displaying the save option. Application.DisplayAlerts = False ActiveWorkbook.Close Application.DisplayAlerts = True If i step through my code as soon as I get to the close bit and move m mouse over application.dis its telling me that it is true. which o coarse make the save option pop up. so I wrote this code in case turned the displayalerts off some where else. If Application.DisplayAlerts = True Then Application.DisplayAlerts False ActiveWorkbook.Close Application.DisplayAlerts = True when I step through it picks it up as being true and does the then bi and then carrys on as it still being true. it seems to be ignoring th fact that I had made it false. I know this works as I have other workbooks that do a similar thing. Any Ideas -- funkymonkU ----------------------------------------------------------------------- funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813 View this thread: http://www.excelforum.com/showthread.php?threadid=51780 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible bug?
When you step through the code, each line of code is like a separate sub.
So when you set it to false and stop, excel changes it back to true. This is not the behavior if you run it normally. A better way to avoid the original problem is ActiveWorkbook.Close SaveChanges:=False and avoid the DisplayAlerts -- Regards, Tom Ogilvy "funkymonkUK" wrote in message ... Hi I got Excell 2000 I have a piece of code which opens a workbook(a) and copys selected sheets to Workbook(B). I then close workbook (A) but do not want the "do you want to save..." display to pop up so I wrote the following code to stop it from displaying the save option. Application.DisplayAlerts = False ActiveWorkbook.Close Application.DisplayAlerts = True If i step through my code as soon as I get to the close bit and move my mouse over application.dis its telling me that it is true. which of coarse make the save option pop up. so I wrote this code in case I turned the displayalerts off some where else. If Application.DisplayAlerts = True Then Application.DisplayAlerts = False ActiveWorkbook.Close Application.DisplayAlerts = True when I step through it picks it up as being true and does the then bit and then carrys on as it still being true. it seems to be ignoring the fact that I had made it false. I know this works as I have other workbooks that do a similar thing. Any Ideas? -- funkymonkUK ------------------------------------------------------------------------ funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135 View this thread: http://www.excelforum.com/showthread...hreadid=517809 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible bug?
seems to be working except it keeps saying the is large amount of dat on the clip board. is there a way to stop tha -- funkymonkU ----------------------------------------------------------------------- funkymonkUK's Profile: http://www.excelforum.com/member.php...fo&userid=1813 View this thread: http://www.excelforum.com/showthread.php?threadid=51780 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible bug?
If you copied a range doing
application.CutCopyMode = False will empty the clipboard. Do this before the code that evokes the message Or you can do Application.DisplayAlerts = False ' code the evokes the message Application.Displayalerts = True -- Regards, Tom Ogilvy "funkymonkUK" wrote in message ... seems to be working except it keeps saying the is large amount of data on the clip board. is there a way to stop that -- funkymonkUK ------------------------------------------------------------------------ funkymonkUK's Profile: http://www.excelforum.com/member.php...o&userid=18135 View this thread: http://www.excelforum.com/showthread...hreadid=517809 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|