View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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