Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() You can code the toolbars, headers and all that to not be displayed. Then upon closing the worksheet, code in a section to reset all the options you turned off.. I do this on a couple of fillable spreadsheets that I generated a VB form process for.. Example: ----------------- On Open Worksheet ----------------- Private Sub Worksheet_Activate() With ActiveWindow .DisplayGridlines = True .DisplayHorizontalScrollBar = False .DisplayVerticalScrollBar = True .DisplayWorkbookTabs = False .DisplayHeadings = False .DisplayFormulas = False End With End Sub ------------------------------------------------- ----------------- On Close Workbook ----------------- Private Sub Workbook_BeforeClose(Cancel As Boolean) With ActiveWindow .DisplayGridlines = True .DisplayHorizontalScrollBar = True .DisplayVerticalScrollBar = True .DisplayWorkbookTabs = True .DisplayHeadings = True .DisplayFormulas = True End With End Sub *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel still running in task manager after closing the application | Excel Discussion (Misc queries) | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Test if application running? | Excel Programming | |||
Find all running Excel Application objects | Excel Programming | |||
Problem in running an application | Excel Programming |