Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 =--- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Customised Axis Values | Charts and Charting in Excel | |||
customised output | Excel Discussion (Misc queries) | |||
customised header and footer | Excel Discussion (Misc queries) | |||
Creating customised calendars | Excel Discussion (Misc queries) | |||
Creating customised new spreadsheets | Excel Programming |