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.

Could you please advise your version of Excel?

"R. SRIKANTH" <(E-Mail Removed)> wrote in message
news:70001691-FC18-44D0-8282-(E-Mail Removed)...
> 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.

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" <(E-Mail Removed)> wrote in message
news:70001691-FC18-44D0-8282-(E-Mail Removed)...
> 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.

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
news:09B44B9D-E169-4744-B1A9-(E-Mail Removed)...
>
> 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" <(E-Mail Removed)> wrote in message
> news:70001691-FC18-44D0-8282-(E-Mail Removed)...
> > 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.
>
>
>

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 <70001691-FC18-44D0-8282-(E-Mail Removed)>,
(E-Mail Removed) 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.
>