Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I asked this question a couple of days ago, but no one left a solution,
or suggestion that will work. Can anyone post code that will disable: 'Remove Split' and 'Unfreeze Panes', on individual sheets or every sheet in a workbook? ....I understand that if I check the Protect workbood for: 'Windows' box in the Protect Workbook dialog box, this will disable 'Remove Split' and 'Unfreeze Panes'. However, when the above option is checked, it causes each sheet window in the workbook to seperate from the main Excel Program window, into the 'multiple document interface' (MDI) style of displaying windows. Then each sheet window will be smallaer that the program main window, with no control buttons in the upper right to expand the window, and each sheet will display a title bar. I don't want that. I would like to display each sheet maxamized to the full program window, and have the user not be permitted to Remove Split, or Unfreeze Panes. Can this be done? Thanks. -Dennis -- Dennis Kessler http://www.denniskessler.com/acupuncture |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disable Unfreeze Panes and Remove Split, how? | Excel Discussion (Misc queries) | |||
2 Questions | New Users to Excel | |||
VB code to copy sheet format to another sheet | Excel Discussion (Misc queries) | |||
How do I Remove a Split from my Comments in Excel 2003? | Excel Discussion (Misc queries) | |||
How do I Remove a Split from my Comments in Excel 2003? | Excel Discussion (Misc queries) |