Posted to microsoft.public.excel.programming

Mr.G[_2_]

external usenet poster

Posts: 1

How do I lock or close t.bars for a workbook?

I want to close the toolbars that is open in Excel when a certain book is
opened. I don't have a problem closing all toolbars and opening all again
when you exit book.

I want VB to select the open ones and replace on exit again.

Any help?

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
Deleting Command Bars on close of a workbook	Stan Bottorff	Excel Programming	1	November 6th 05 04:13 AM
Help on Workbook close and workbook save events	Adam Harding	Excel Programming	1	September 29th 05 04:12 PM
Hide all Excel tool/command bars except mine and reload on close	Matt Jensen	Excel Programming	2	December 20th 04 05:44 PM
Close a the current workbook and load another specified workbook	Adrian[_7_]	Excel Programming	4	August 7th 04 05:29 PM
Close button on Custom Menu Bars	Aaron[_6_]	Excel Programming	2	July 18th 03 03:58 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us