Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Why does shared workbooks uncheck users Windows in Taskbar option
Every time users go into a shared workbook it unchecks their previously
selected option to show Windows In Taskbar (Tools\Option\View\Windows In Taskbar). I've tried saving the program with this option checked but it seems every time I make it a shared workbook and go back into it, this option unchecks itself. Any way around this? |
#2
|
|||
|
|||
What version of excel are you running?
Saved from a previous post... There's a bug in xl2k that shows up if you're working with shared workbooks. If you're not using xl2k and shared workbooks, it sounds like you don't have permission to save this setting in your windows registry. I'd talk to my IT folks to find out if they can fix it. but if you're running xl2k.... 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 jasonstratton wrote: Every time users go into a shared workbook it unchecks their previously selected option to show Windows In Taskbar (Tools\Option\View\Windows In Taskbar). I've tried saving the program with this option checked but it seems every time I make it a shared workbook and go back into it, this option unchecks itself. Any way around this? -- Dave Peterson |
#3
|
|||
|
|||
Thanks Dave, it is Excel 2000.
"Dave Peterson" wrote: What version of excel are you running? Saved from a previous post... There's a bug in xl2k that shows up if you're working with shared workbooks. If you're not using xl2k and shared workbooks, it sounds like you don't have permission to save this setting in your windows registry. I'd talk to my IT folks to find out if they can fix it. but if you're running xl2k.... 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 jasonstratton wrote: Every time users go into a shared workbook it unchecks their previously selected option to show Windows In Taskbar (Tools\Option\View\Windows In Taskbar). I've tried saving the program with this option checked but it seems every time I make it a shared workbook and go back into it, this option unchecks itself. Any way around this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How many users can sucessfully use a shared excel workbook? | Excel Worksheet Functions | |||
suddenly my excel workbooks are "shared workbooks" | Excel Discussion (Misc queries) | |||
Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
The colors should work properly in Shared Excel Workbooks. | Excel Worksheet Functions |