View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pnocero pnocero is offline
external usenet poster
 
Posts: 1
Default 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?