View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Edd[_2_] Edd[_2_] is offline
external usenet poster
 
Posts: 22
Default Status & Formula Bar Disabling Prevention Among Other Opened Workb

HI,

I want to disable the Status and Formula bars for a workbook when it is
opened but only for this one specific workbook and not for any other opened
workbooks. I use the below two lines of code.

Application.DisplayStatusBar = False
Application.DisplayFormulaBar = False

How can I prevent these actions from occuring with other opened workbooks?

Thanks,