No macros but still Excel displaying messages everytime I open Exc

Hi,

I had copied one of the macros on conditional formatting from this forum and
created using the 'View Code' option on the sheet tab. Things worked fine,
but then I didn't want that macro any longer, so went to the sheet tab again,
right clicked there and clicked on 'View Code' again. There I saw the macro
code, which I selected by selecting CRTL+A and then deleted. I saved my
workbook and closed it. From next time onwards when I am opening the workbook
it gives me a message that it has disabled a macro since it is not trusted.
The security for macro is set to high from the beginning. The thing is
there's no macro in my Excel file then why is Excel asking me everytime I
open that Excel file again. I tried a lot but can't remove that message from
coming everytime I open that Excel file. Please help on how to remove that
pop-up message coming everytime.

Thank you so much.

Press Alt-F11 to bring up the VBA editor. In the left window pane, locate
'Modules'. Click the plus (+) to expand (if not already expanded). If
there are modules shown below that, then you will need to remove them.
Right-click and remove.

HTH,
Paul



"Excel Learner" <Excel Learner@discussions.microsoft.com> wrote in message
news:CE4FB689-CEE3-4EFF-9B9F-0AC7E3EF1D68@microsoft.com...
> Hi,
>
> I had copied one of the macros on conditional formatting from this forum
> and
> created using the 'View Code' option on the sheet tab. Things worked fine,
> but then I didn't want that macro any longer, so went to the sheet tab
> again,
> right clicked there and clicked on 'View Code' again. There I saw the
> macro
> code, which I selected by selecting CRTL+A and then deleted. I saved my
> workbook and closed it. From next time onwards when I am opening the
> workbook
> it gives me a message that it has disabled a macro since it is not
> trusted.
> The security for macro is set to high from the beginning. The thing is
> there's no macro in my Excel file then why is Excel asking me everytime I
> open that Excel file again. I tried a lot but can't remove that message
> from
> coming everytime I open that Excel file. Please help on how to remove that
> pop-up message coming everytime.
>
> Thank you so much.

You may have a module in your workbook with nothing in it.
Within your workbook type ALT F11.
They type CTRL R

Review the modules in the workbook in question. Delete if nothing is there.

"Excel Learner" wrote:

> Hi,
>
> I had copied one of the macros on conditional formatting from this forum and
> created using the 'View Code' option on the sheet tab. Things worked fine,
> but then I didn't want that macro any longer, so went to the sheet tab again,
> right clicked there and clicked on 'View Code' again. There I saw the macro
> code, which I selected by selecting CRTL+A and then deleted. I saved my
> workbook and closed it. From next time onwards when I am opening the workbook
> it gives me a message that it has disabled a macro since it is not trusted.
> The security for macro is set to high from the beginning. The thing is
> there's no macro in my Excel file then why is Excel asking me everytime I
> open that Excel file again. I tried a lot but can't remove that message from
> coming everytime I open that Excel file. Please help on how to remove that
> pop-up message coming everytime.
>
> Thank you so much.

You may have a module in your workbook with nothing in it.
Within your workbook type ALT F11.
They type CTRL R

Review the modules in the workbook in question. Delete if nothing is there.

"Excel Learner" wrote:

> Hi,
>
> I had copied one of the macros on conditional formatting from this forum and
> created using the 'View Code' option on the sheet tab. Things worked fine,
> but then I didn't want that macro any longer, so went to the sheet tab again,
> right clicked there and clicked on 'View Code' again. There I saw the macro
> code, which I selected by selecting CRTL+A and then deleted. I saved my
> workbook and closed it. From next time onwards when I am opening the workbook
> it gives me a message that it has disabled a macro since it is not trusted.
> The security for macro is set to high from the beginning. The thing is
> there's no macro in my Excel file then why is Excel asking me everytime I
> open that Excel file again. I tried a lot but can't remove that message from
> coming everytime I open that Excel file. Please help on how to remove that
> pop-up message coming everytime.
>
> Thank you so much.

You may have a module in your workbook with nothing in it.
Within your workbook type ALT F11.
They type CTRL R

Review the modules in the workbook in question. Delete if nothing is there.

"Excel Learner" wrote:

> Hi,
>
> I had copied one of the macros on conditional formatting from this forum and
> created using the 'View Code' option on the sheet tab. Things worked fine,
> but then I didn't want that macro any longer, so went to the sheet tab again,
> right clicked there and clicked on 'View Code' again. There I saw the macro
> code, which I selected by selecting CRTL+A and then deleted. I saved my
> workbook and closed it. From next time onwards when I am opening the workbook
> it gives me a message that it has disabled a macro since it is not trusted.
> The security for macro is set to high from the beginning. The thing is
> there's no macro in my Excel file then why is Excel asking me everytime I
> open that Excel file again. I tried a lot but can't remove that message from
> coming everytime I open that Excel file. Please help on how to remove that
> pop-up message coming everytime.
>
> Thank you so much.

Hello Barb and PCLIVE,

Thank you so much. After I followed the steps you mentioned I am now able to
open the Excel file as always.

God bless you for the quick help I was in need of.

Thanks again.

"PCLIVE" wrote:

> Press Alt-F11 to bring up the VBA editor. In the left window pane, locate
> 'Modules'. Click the plus (+) to expand (if not already expanded). If
> there are modules shown below that, then you will need to remove them.
> Right-click and remove.
>
> HTH,
> Paul
>
>
>
> "Excel Learner" <Excel Learner@discussions.microsoft.com> wrote in message
> news:CE4FB689-CEE3-4EFF-9B9F-0AC7E3EF1D68@microsoft.com...
> > Hi,
> >
> > I had copied one of the macros on conditional formatting from this forum
> > and
> > created using the 'View Code' option on the sheet tab. Things worked fine,
> > but then I didn't want that macro any longer, so went to the sheet tab
> > again,
> > right clicked there and clicked on 'View Code' again. There I saw the
> > macro
> > code, which I selected by selecting CRTL+A and then deleted. I saved my
> > workbook and closed it. From next time onwards when I am opening the
> > workbook
> > it gives me a message that it has disabled a macro since it is not
> > trusted.
> > The security for macro is set to high from the beginning. The thing is
> > there's no macro in my Excel file then why is Excel asking me everytime I
> > open that Excel file again. I tried a lot but can't remove that message
> > from
> > coming everytime I open that Excel file. Please help on how to remove that
> > pop-up message coming everytime.
> >
> > Thank you so much.
>
>
>