Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Yes no drop down list and macros
I have an excel sheet that get imported into another workbook by way of a
macro.. This sheet contains two drop down lists. When I run the macro I get an info box that pops up telling me: "A formula or sheet you want to move or copy contains the 'YES_NO' which already exists on the destination worksheet. Do you want to use this version of the name?" Can I add any code to the macro to always say yes to this and not see the dialogue box ?? -- Thanks Larry |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Yes no drop down list and macros
Try
Sub Macro() Application.DisplayAlerts = False 'your code here Application.DisplayAlerts = True End Sub If this post helps click Yes --------------- Jacob Skaria "Larry Fitch" wrote: I have an excel sheet that get imported into another workbook by way of a macro.. This sheet contains two drop down lists. When I run the macro I get an info box that pops up telling me: "A formula or sheet you want to move or copy contains the 'YES_NO' which already exists on the destination worksheet. Do you want to use this version of the name?" Can I add any code to the macro to always say yes to this and not see the dialogue box ?? -- Thanks Larry |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Yes no drop down list and macros
I did not test but try
Application.DisplayAlerts=false and then reset after the copy Application.DisplayAlerts=true I know this works to suppress the message when deleting sheets -- If this helps, please remember to click yes. "Larry Fitch" wrote: I have an excel sheet that get imported into another workbook by way of a macro.. This sheet contains two drop down lists. When I run the macro I get an info box that pops up telling me: "A formula or sheet you want to move or copy contains the 'YES_NO' which already exists on the destination worksheet. Do you want to use this version of the name?" Can I add any code to the macro to always say yes to this and not see the dialogue box ?? -- Thanks Larry |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Yes no drop down list and macros
THanks Jacob..
That worked great !!! If I could ask another question... In the macro below I am able to source the input sheet I am looking for and then I bascially do a copy and paste into my workbook - Sub Statistics_Input() ' ' Statistics_Input Macro ' ' Keyboard Shortcut: Ctrl+q ' Application.DisplayAlerts = False Application.ScreenUpdating = False FOpen = Application.Dialogs(xlDialogOpen).Show(ThisWorkboo k.Path) Range("C10:D88").Select Selection.Copy Windows(ThisWorkbook.Name).Activate Sheets("Statistics").Select Range("C10:D88").Select ActiveSheet.Paste Sheets("Selection Sheet").Select Application.DisplayAlerts = True End Sub I cannot figure out how to close the source document after the cut and paste.. -- Thanks Larry "Jacob Skaria" wrote: Try Sub Macro() Application.DisplayAlerts = False 'your code here Application.DisplayAlerts = True End Sub If this post helps click Yes --------------- Jacob Skaria "Larry Fitch" wrote: I have an excel sheet that get imported into another workbook by way of a macro.. This sheet contains two drop down lists. When I run the macro I get an info box that pops up telling me: "A formula or sheet you want to move or copy contains the 'YES_NO' which already exists on the destination worksheet. Do you want to use this version of the name?" Can I add any code to the macro to always say yes to this and not see the dialogue box ?? -- Thanks Larry |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Yes no drop down list and macros
Try the below
Dim wb As Workbook Application.DisplayAlerts = False Application.ScreenUpdating = False Application.Dialogs(xlDialogOpen).Show ThisWorkbook.Path Set wb = ActiveWorkbook wb.ActiveSheet.Range("C10:D88").Copy _ ThisWorkbook.Sheets("Statistics").Range("C10") wb.Close False Application.DisplayAlerts = True Application.ScreenUpdating = True If this post helps click Yes --------------- Jacob Skaria "Larry Fitch" wrote: THanks Jacob.. That worked great !!! If I could ask another question... In the macro below I am able to source the input sheet I am looking for and then I bascially do a copy and paste into my workbook - Sub Statistics_Input() ' ' Statistics_Input Macro ' ' Keyboard Shortcut: Ctrl+q ' Application.DisplayAlerts = False Application.ScreenUpdating = False FOpen = Application.Dialogs(xlDialogOpen).Show(ThisWorkboo k.Path) Range("C10:D88").Select Selection.Copy Windows(ThisWorkbook.Name).Activate Sheets("Statistics").Select Range("C10:D88").Select ActiveSheet.Paste Sheets("Selection Sheet").Select Application.DisplayAlerts = True End Sub I cannot figure out how to close the source document after the cut and paste.. -- Thanks Larry "Jacob Skaria" wrote: Try Sub Macro() Application.DisplayAlerts = False 'your code here Application.DisplayAlerts = True End Sub If this post helps click Yes --------------- Jacob Skaria "Larry Fitch" wrote: I have an excel sheet that get imported into another workbook by way of a macro.. This sheet contains two drop down lists. When I run the macro I get an info box that pops up telling me: "A formula or sheet you want to move or copy contains the 'YES_NO' which already exists on the destination worksheet. Do you want to use this version of the name?" Can I add any code to the macro to always say yes to this and not see the dialogue box ?? -- Thanks Larry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Drop Down List of Macros | Excel Discussion (Misc queries) | |||
ASSIG MACROS TO DROP DOWN LIST | Excel Discussion (Misc queries) | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
Delete key not enabled on macros drop down list | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |