LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hal Hal is offline
external usenet poster
 
Posts: 36
Default Toolbars: Hide now, display later

I want to code a procedure which will make note of all currently active
toolbars when the workbook opens. I then want to hide those toolbars and
display only the custom toolbar I have. Once I am done with this workbook, I
want to reactivate the previously active toolbars.

The following code hides them all with the exception of the Adobe pdf maker
6.0 toobar. Your ideas and solutions are appreciated.

Hal

Private Sub Auto_Open ()

S1$ = Application.CommandBars.Count
For Each bar In Application.CommandBars
If bar.BuiltIn And Not S1$ = 0 Then bar.Enabled = Flase
S1$ = S1$ -1
Next

End Sub


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
hide toolbars, menu bar, etc runandrun Excel Discussion (Misc queries) 0 September 22nd 05 10:16 PM
Hide And Un-hide Excel Toolbars Jim333[_4_] Excel Programming 3 July 2nd 05 08:00 PM
Hide Toolbars Jennifer Excel Programming 3 January 17th 05 02:55 PM
Hide toolbars Lawlera Excel Programming 3 February 3rd 04 03:37 PM
Hide all toolbars auto_open Nigel Cummins Excel Programming 0 July 9th 03 10:17 AM


All times are GMT +1. The time now is 10:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"