| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to depress confirmation dailog
I have an excel sheet where I have written some codes to run when the file
opens. It works fine. But every time when it opens, it needs confirmation ENABLE MACRO OR DISABLE MACRO. I dont want the user to get this dailog box. As I have deliver this file to another users where I dont them to view the code neither I want them to apprear this selection dailog box. Any suggestion for doing this. Regards Irshad |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to depress confirmation dailog
Irshad
Signing the code or making the workbook an add-in and installing that manually or via an installer will stop the dialog -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Irshad Alam" wrote in message ... I have an excel sheet where I have written some codes to run when the file opens. It works fine. But every time when it opens, it needs confirmation ENABLE MACRO OR DISABLE MACRO. I dont want the user to get this dailog box. As I have deliver this file to another users where I dont them to view the code neither I want them to apprear this selection dailog box. Any suggestion for doing this. Regards Irshad |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Confirmation Security | Excel Worksheet Functions | |||
| A question about the confirmation | Excel Discussion (Misc queries) | |||
| How to stop a Smart Tag Login Dailog box when excel opens | Excel Discussion (Misc queries) | |||
| Getting rid of confirmation boxes | New Users to Excel | |||
| Depress Icon Faces and not the Caption on CommandBarButton | Excel Programming | |||
Linear Mode
