Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Macros
Sir
i opened a worksheet and recorded a macro. after disabling the macro in the dialog box, i opened again in another terminal but the security dialog box appears on the screen. also i would be sending reports to others through the mail. i would like to know what procedure to be used, so that startup macro dialog box does not appear on the screen when opening the worksheet. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Macros
Could you please advise your version of Excel?
"R. SRIKANTH" wrote in message ... Sir, i opened a worksheet and recorded a macro. after disabling the macro in the dialog box, i opened again in another terminal but the security dialog box appears on the screen. also i would be sending reports to others through the mail. i would like to know what procedure to be used, so that startup macro dialog box does not appear on the screen when opening the worksheet. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Macros
My system version is Xp whereas my colleague version is 97. when i disable the macros in the XP version and if i open in the 97 version the startup macro dialog appears. i would like to know how to hide the macros so that no one is able to see the macro file. ----- Rob van Gelder wrote: ----- Could you please advise your version of Excel? "R. SRIKANTH" wrote in message ... Sir, i opened a worksheet and recorded a macro. after disabling the macro in the dialog box, i opened again in another terminal but the security dialog box appears on the screen. also i would be sending reports to others through the mail. i would like to know what procedure to be used, so that startup macro dialog box does not appear on the screen when opening the worksheet. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Macros
If you could disable the macro warning, that would defeat the purpose of
having it. In Excel 97, you have no options. In xl2000 or later, you can certify your workbook, and after the user accepts you as a trusted source, they would not be prompted. -- Regards, Tom Ogilvy "RAMASWAMY SRIKANTH" <ramasam wrote in message ... My system version is Xp whereas my colleague version is 97. when i disable the macros in the XP version and if i open in the 97 version the startup macro dialog appears. i would like to know how to hide the macros so that no one is able to see the macro file. ----- Rob van Gelder wrote: ----- Could you please advise your version of Excel? "R. SRIKANTH" wrote in message ... Sir, i opened a worksheet and recorded a macro. after disabling the macro in the dialog box, i opened again in another terminal but the security dialog box appears on the screen. also i would be sending reports to others through the mail. i would like to know what procedure to be used, so that startup macro dialog box does not appear on the screen when opening the worksheet. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Macros
If you are trying to avoid the warning, consider creating an add-in
(http://www.google.com/groups?selm=MP...2ccd5ce98a88c% 40msnews.microsoft.com) If you are trying to get rid off the macro, switch to the VB Editor and *remove* the module that contains the macro. -- Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Sir, i opened a worksheet and recorded a macro. after disabling the macro in the dialog box, i opened again in another terminal but the security dialog box appears on the screen. also i would be sending reports to others through the mail. i would like to know what procedure to be used, so that startup macro dialog box does not appear on the screen when opening the worksheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disabling macros | Excel Discussion (Misc queries) | |||
Disabling/Enabling Macros | Excel Programming | |||
preventing disabling of macros | Excel Programming | |||
disabling Auto_Open macros | Excel Programming | |||
Enabling/Disabling Macros | Excel Programming |