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 |
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 |
All times are GMT +1. The time now is 07:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com