View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_6_] Nigel[_6_] is offline
external usenet poster
 
Posts: 68
Default Customised Interface

What is the recommended method of turning of all command bars etc.?
I need to save the environment on entry and restore it before leaving.
Currently I have the following code set up

' set up environment on wayin
With ActiveWindow
.DisplayGridlines = False
.DisplayHeadings = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
End With
Application.DisplayFullScreen = True
Application.CommandBars("Full Screen").Enabled = False

I reverse the above steps on the way out, but of course this does not take
account of the users settings before I make these changes.

TIA
Nigel




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---