Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Splashscreens and macros from external aps
I have a program that collects information on Access or Excel files from
Access. But when run it sometimes brings up splashscreens or something that requires action, which I don;t want in a batch process. Is there a way of supressing it? Application.displayalerts doesn't work. Can you supress code being run in a workbook open event? I'm using one workbook to open others. Can I open another in a way that prevents that workbooks open event from running a splashscreen or other code? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Splashscreens and macros from external aps
I had exactly the same problem where message boxs were in the open
workbook event, however it is very easy to overcome just disable the events. The code is: Application.EnableEvents = False Just remember to switch them back on at the end of your code! I hope that helps. James (Spammastergrand) wrote in message ... I have a program that collects information on Access or Excel files from Access. But when run it sometimes brings up splashscreens or something that requires action, which I don;t want in a batch process. Is there a way of supressing it? Application.displayalerts doesn't work. Can you supress code being run in a workbook open event? I'm using one workbook to open others. Can I open another in a way that prevents that workbooks open event from running a splashscreen or other code? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Splashscreens and macros from external aps
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Splashscreens and macros from external aps
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Splashscreens and macros from external aps
Yeah you just need to switch the automatic calculation off, you can do
this with the following: Application.Calculation = xlManual The other option you have is whether to calculate the spreadsheet before saving it which is: Application.CalculateBeforeSave = False But that all depends on what you are trying to do. Again I think you may need to switch these both back on when your finished so you can you use: Application.Calculation = xlAutomatic Any Problems then give me a shout. James (Spammastergrand) wrote in message ... Is there code to stop calculation from happening with formulas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disabling macros | Excel Discussion (Misc queries) | |||
Disabling Macros | Excel Programming | |||
Disabling/Enabling Macros | Excel Programming | |||
Disabling external data refresh using vba | Excel Programming | |||
preventing disabling of macros | Excel Programming |