Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control save prompts in VB code
How do I control the prompts so end users do not have to answer "enable
macros" questions and "There is alraeady a file saving it will overwrite it |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control save prompts in VB code
The only ways (that I know) to do this a
Use a certificate (self cert) or Build an add-in with all the code needed and have the user add it to there add-ins. These open behind the scene each time Excel is opened. or Build a workbook with all the code and have the user save it in the XlStart folder. These also open behind the scene each time Excel is opened. Than you can have your "special" workbooks have code to open any file without prompts. -- steveB Remove "AYN" from email to respond "bobcat" wrote in message ... How do I control the prompts so end users do not have to answer "enable macros" questions and "There is alraeady a file saving it will overwrite it |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Control save prompts in VB code
Using the following code should work:
Application.DisplayAlerts = False If you only want to disable the prompts for one function only, say when closing a workbook you can then enable them again afterwards as follows: Application.DisplayAlerts = False Workbooks("BOOK1.XLS").Close Application.DisplayAlerts = True I hope that helps. Graham bobcat wrote: How do I control the prompts so end users do not have to answer "enable macros" questions and "There is alraeady a file saving it will overwrite it |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save Prompts | Excel Worksheet Functions | |||
print prompts save as | New Users to Excel | |||
Exiting Excel prompts for save | Excel Discussion (Misc queries) | |||
Save without prompts | Excel Programming | |||
Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions |