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? |
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 |
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 |
All times are GMT +1. The time now is 05:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com