| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Click "Ok" without prompting - Macro
Hi,
I have created a Macro and i have used "Text to Column" option in it. Now when i run the Macro it promts me if i want to "Replace the Contents of Destination Cell". This should always be Yes. Is there a way i can make this yes without it asking all the time. As this will be used by multiple users i dont want them to be confused by this question. Does somebody have a solution??? Thanks & Regards, Aziz. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Click "Ok" without prompting - Macro
Try:
application.DisplayAlerts = false <your stuff application.DisplayAlerts = True HTH -- AP "Aziz Ahmedabadwala" a écrit dans le message de news: ... Hi, I have created a Macro and i have used "Text to Column" option in it. Now when i run the Macro it promts me if i want to "Replace the Contents of Destination Cell". This should always be Yes. Is there a way i can make this yes without it asking all the time. As this will be used by multiple users i dont want them to be confused by this question. Does somebody have a solution??? Thanks & Regards, Aziz. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Click "Ok" without prompting - Macro
Hi Aziz,
Try: Application.DisplayAlerts = False 'Your TextToColumns code Application.DisplayAlerts = True --- Regards, Norman "Aziz Ahmedabadwala" wrote in message ... Hi, I have created a Macro and i have used "Text to Column" option in it. Now when i run the Macro it promts me if i want to "Replace the Contents of Destination Cell". This should always be Yes. Is there a way i can make this yes without it asking all the time. As this will be used by multiple users i dont want them to be confused by this question. Does somebody have a solution??? Thanks & Regards, Aziz. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Click "Ok" without prompting - Macro
Grt.. yes it works.........
"Norman Jones" wrote: Hi Aziz, Try: Application.DisplayAlerts = False 'Your TextToColumns code Application.DisplayAlerts = True --- Regards, Norman "Aziz Ahmedabadwala" wrote in message ... Hi, I have created a Macro and i have used "Text to Column" option in it. Now when i run the Macro it promts me if i want to "Replace the Contents of Destination Cell". This should always be Yes. Is there a way i can make this yes without it asking all the time. As this will be used by multiple users i dont want them to be confused by this question. Does somebody have a solution??? Thanks & Regards, Aziz. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Click "Ok" without prompting - Macro
Grt.. yes it works.........
"Ardus Petus" wrote: Try: application.DisplayAlerts = false <your stuff application.DisplayAlerts = True HTH -- AP "Aziz Ahmedabadwala" a écrit dans le message de news: ... Hi, I have created a Macro and i have used "Text to Column" option in it. Now when i run the Macro it promts me if i want to "Replace the Contents of Destination Cell". This should always be Yes. Is there a way i can make this yes without it asking all the time. As this will be used by multiple users i dont want them to be confused by this question. Does somebody have a solution??? Thanks & Regards, Aziz. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Click "Ok" without prompting - Macro
This works; however, my contents still do not 'replace'. What is missing?
When I perform Text to Column without the macro, the contents replace just fine. Mike Portland,OR "Ardus Petus" wrote: Try: application.DisplayAlerts = false <your stuff application.DisplayAlerts = True HTH -- AP "Aziz Ahmedabadwala" a écrit dans le message de news: ... Hi, I have created a Macro and i have used "Text to Column" option in it. Now when i run the Macro it promts me if i want to "Replace the Contents of Destination Cell". This should always be Yes. Is there a way i can make this yes without it asking all the time. As this will be used by multiple users i dont want them to be confused by this question. Does somebody have a solution??? Thanks & Regards, Aziz. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
| How do I get "file" tab to click on, it starts with "edit" | Excel Discussion (Misc queries) | |||
| "File Not Found" prompting | Excel Programming | |||
| Worksheets("Brackets").DropDowns("Game10").Click | Excel Programming | |||
| commnd button - when i rt click, "assign macro" isnt an option... | Excel Programming | |||
![Aziz Ahmedabadwala[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
