Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is there anyway to keep this from happening?
|
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Saved from a previous post:
Is the workbook shared? (A bug in xl2k turns it off for shared workbooks.) You could create a new workbook saved into XLStart (or put this into your personal.xls workbook) and it'll toggle that option each time you open a workbook. In the ThisWorkbook module: Option Explicit Public WithEvents xlApp As Excel.Application Private Sub Workbook_Open() Set xlApp = Application End Sub Private Sub Workbook_Close() Set xlApp = Nothing End Sub Private Sub xlApp_NewWorkbook(ByVal Wb As Workbook) Application.ShowWindowsInTaskbar = True End Sub Private Sub xlApp_WorkbookOpen(ByVal Wb As Workbook) Application.ShowWindowsInTaskbar = True End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm ariggs wrote: Is there anyway to keep this from happening? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Make merged cells a feature that can be used in a shared workbook | Excel Worksheet Functions | |||
Why do I lose data in a shared workbook? | Excel Discussion (Misc queries) | |||
If protecting a sheet I lose the autosum feature, any way around | Excel Discussion (Misc queries) | |||
Why does shared workbooks uncheck users Windows in Taskbar option | Excel Discussion (Misc queries) | |||
how do I synchronize shared workbook feature in WSS? | Excel Discussion (Misc queries) |