| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
turn off messagess
Hi guys and girls,
There is a way to turn off any kind on message pop ups in excel. does any one know how? thank you *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
turn off messagess
at start of code
application.displayalerts = false at end of code application.displayalerts = true -- Robin Hammond www.enhanceddatasystems.com Check out our XspandXL add-in "excel programming" <http://communities.microsoft.com/new...rod_office&slc id=US wrote in message ... Hi guys and girls, There is a way to turn off any kind on message pop ups in excel. does any one know how? thank you *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
turn off messagess
at end of code
application.displayalerts = true At the end of code Excel automatically resets alerts. I don't think I've ever used the above line of code. Did I ever want Excel alerts in the middle of my code? I don't think so. -- Jim Rech Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Links - hoe to turn them off | Excel Discussion (Misc queries) | |||
| Turn Off New UI | New Users to Excel | |||
| WHY DOES 1E4 TURN INTO 1.00 E + 04? THANKS | Excel Discussion (Misc queries) | |||
| How do i turn it off | Excel Discussion (Misc queries) | |||
| Turn Off Formula ? | New Users to Excel | |||
![excel programming[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
