LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default getting rid of of a pop-up massage box

Nigel

Indeed it will not, but the OPs original request was to stop that particular
warning, not all warnings in the code.

Granted, Application.DisplayAlerts works, but he may have wanted to show
some, save workbook, etc.

--
HTH
Nick Hodge
Southampton, England



"Nigel Brown" wrote in message
om...
"Nick Hodge" wrote in message

...
Nick

Not sure if

Application.CutCopyMode=False

will help, but if not, copy an empty cell in between actions should do

it

--

Yes it will but it will not disable pop-ups for the entirity of the
macro. To achieve this, use:
Application.DisplayAlerts=False

HTH
Nigel
p.s Funny Freudian slip :)



 
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
how to apply Warning massage deepak Excel Discussion (Misc queries) 3 May 6th 10 03:28 PM
I CANNOT HIDE COLUM & I GOT ERROR MASSAGE "CANNOT SHIFT PBJECTS O. ALAA Excel Worksheet Functions 1 March 11th 09 07:02 AM
help on value error massage please. anier614 Excel Discussion (Misc queries) 3 October 17th 07 09:36 PM
Popup Massage Windows shital Excel Programming 1 August 23rd 03 05:17 PM


All times are GMT +1. The time now is 04:39 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"