ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Customised Interface (https://www.excelbanter.com/excel-programming/281272-customised-interface.html)

Nigel[_6_]

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 =---


All times are GMT +1. The time now is 08:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com