LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,355
Default No macros but still Excel displaying messages everytime I open Exc

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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to stop running macros everytime I run excel? SusieOrtiz Excel Discussion (Misc queries) 1 August 18th 09 05:20 AM
EULA keeps popping up everytime I open EXCEL sfbayramfan Setting up and Configuration of Excel 1 May 7th 08 11:02 PM
how can I open an excel file everytime on certain sheet? Inas Excel Discussion (Misc queries) 1 June 7th 07 12:28 PM
How do I set up an excel doc. to open on the same tab everytime Dana Stricker Excel Discussion (Misc queries) 2 November 17th 05 07:54 PM


All times are GMT +1. The time now is 06:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"