Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro disable and enable.
I need help with 3 question, please help!!!
1.is is possible to have excel not to prompt user to disable and enable a macro? If yes, how could it be done? 2.i have a macro that is called from a word document. whenever this process is completed it will show the excel workbook. is possible to make this workbook invisible? 3.instead of the work book, i will like to have a statement, saying macro completed. Is this possible. i look forward for any help. thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro disable and enable.
1 - no
2 - oxlapp.Visible = false 3 - msgbox "done" -- Regards, Tom Ogilvy "paul" wrote in message ... I need help with 3 question, please help!!! 1.is is possible to have excel not to prompt user to disable and enable a macro? If yes, how could it be done? 2.i have a macro that is called from a word document. whenever this process is completed it will show the excel workbook. is possible to make this workbook invisible? 3.instead of the work book, i will like to have a statement, saying macro completed. Is this possible. i look forward for any help. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enable/Disable Macro Pop-Up | Excel Discussion (Misc queries) | |||
Macro Enable/Disable Pop-Up Warning | Excel Discussion (Misc queries) | |||
how to disable/enable command button(ActiveX) using macro | Excel Discussion (Misc queries) | |||
File opens with Enable or Disable Macro | Excel Discussion (Misc queries) | |||
enable/disable macro | Excel Discussion (Misc queries) |