Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Does Conditional Formatting create macros in my workbook?
I created a template for a shared workbook that has a lot of conditional
formatting in it. I did not create any macros, but when I open the file, I get a message that the file contains macros. Does conditional formatting create macros in my file? My security setting is set to Medium, and I'm not understanding why I get this message. Any help would be great. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Does Conditional Formatting create macros in my workbook?
Possibly you created a module in your workbook. If you have a module (look
in the project explore in the VBE), you will get this message even if there is no code in the module. Delete the module Save the workbook If that doesn't clear it up, go to each sheet module, click in it, do Ctrl+A, hit delete, close it. Also in the thisworkbook module Save the workbook. -- Regards, Tom Ogilvy "Kristin" wrote: I created a template for a shared workbook that has a lot of conditional formatting in it. I did not create any macros, but when I open the file, I get a message that the file contains macros. Does conditional formatting create macros in my file? My security setting is set to Medium, and I'm not understanding why I get this message. Any help would be great. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Does Conditional Formatting create macros in my workbook?
How do I delete a module? I do have a blank module, but can't seem to delete
it. Thanks! "Tom Ogilvy" wrote: Possibly you created a module in your workbook. If you have a module (look in the project explore in the VBE), you will get this message even if there is no code in the module. Delete the module Save the workbook If that doesn't clear it up, go to each sheet module, click in it, do Ctrl+A, hit delete, close it. Also in the thisworkbook module Save the workbook. -- Regards, Tom Ogilvy "Kristin" wrote: I created a template for a shared workbook that has a lot of conditional formatting in it. I did not create any macros, but when I open the file, I get a message that the file contains macros. Does conditional formatting create macros in my file? My security setting is set to Medium, and I'm not understanding why I get this message. Any help would be great. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Does Conditional Formatting create macros in my workbook?
right click on it in the project explorer and select Remove ModuleName
-- Regards, Tom Ogilvy "Kristin" wrote in message ... How do I delete a module? I do have a blank module, but can't seem to delete it. Thanks! "Tom Ogilvy" wrote: Possibly you created a module in your workbook. If you have a module (look in the project explore in the VBE), you will get this message even if there is no code in the module. Delete the module Save the workbook If that doesn't clear it up, go to each sheet module, click in it, do Ctrl+A, hit delete, close it. Also in the thisworkbook module Save the workbook. -- Regards, Tom Ogilvy "Kristin" wrote: I created a template for a shared workbook that has a lot of conditional formatting in it. I did not create any macros, but when I open the file, I get a message that the file contains macros. Does conditional formatting create macros in my file? My security setting is set to Medium, and I'm not understanding why I get this message. Any help would be great. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting and Macros in Excel | New Users to Excel | |||
How do I create a task from conditional formatting? | Excel Worksheet Functions | |||
How do I create conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting based on decision to enable/disable macros? | Excel Discussion (Misc queries) | |||
Conditional Formatting using Event Macros | Excel Programming |