Disabling Macros

[Guest]

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.

 

[Rob van Gelder]

Could you please advise your version of Excel?

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.

 

[Guest]

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?

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.

 

[Tom Ogilvy]

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

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.

 

[Tushar Mehta]

If you are trying to avoid the warning, consider creating an add-in
(http://www.google.com/groups?selm=MPG.185a8ddd52ccd5ce98a88c%
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