Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
workbook_open() does not execute if there are conditional formats
I have a large and complex workbook that uses workbook_open() to execute some
simple code at startup (it requests the entry of the user's name). This code does not execute if I have any conditional formatting on the first worksheet. If I remove all conditional formatting from the first worksheet, it works fine; if I leave the formatting in place, it does not execute. Any ideas what is happening here? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
workbook_open() does not execute if there are conditional formats
1. what is your code ?
2. what are the conditional formats ? 3. try removing any OnError statements - they may be masking the problem. -- Gary''s Student - gsnu200852 "pnocero" wrote: I have a large and complex workbook that uses workbook_open() to execute some simple code at startup (it requests the entry of the user's name). This code does not execute if I have any conditional formatting on the first worksheet. If I remove all conditional formatting from the first worksheet, it works fine; if I leave the formatting in place, it does not execute. Any ideas what is happening here? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formats- paste special formats? | Excel Discussion (Misc queries) | |||
Conditional Formats | Excel Discussion (Misc queries) | |||
paste conditional formats as formats | Excel Discussion (Misc queries) | |||
Conditional Formats | Excel Discussion (Misc queries) | |||
Any way to have more than three conditional formats? | Excel Worksheet Functions |