Posted to microsoft.public.excel.programming

Edd[_2_]

external usenet poster

Posts: 22

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,

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
reuest formula for auto update status & status date	PERANISH	Excel Worksheet Functions	5	June 2nd 08 04:26 PM
Prevention of Printing	Deejay	Excel Discussion (Misc queries)	1	September 25th 07 12:20 PM
Closing Form and prevention	C_Ascheman[_2_]	Excel Programming	3	February 23rd 07 04:51 PM
Excel Question Prevention	Help?[_2_]	Excel Programming	2	October 30th 06 07:47 PM
write a formula to sum cells on different pages of the same workb.	Kestle	Excel Worksheet Functions	1	November 8th 04 07:53 PM

All times are GMT +1. The time now is 04:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us