Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / November 2004

Tip: Looking for answers? Try searching our database.

Share workbook affects my "options menu" configuration

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
f_31416_ron - 18 Nov 2004 15:45 GMT
A share workbook affects my "options/ view/ windows in task bar"
configuration each time I open it. How can I avoid it? I have modified and
saved this option in the share workbook but it hasn't solved the problem.
Dave Peterson - 19 Nov 2004 02:38 GMT
From a previous post:

Do you use Shared workbooks.  If yes, there's a problem with that setting and
shared workbooks (but it's been fixed in xl2002--so that should help <bg>).

You could use an application event that resets that option each time a workbook
opens--until you upgrade:

If you like this idea:

Start a new workbook
Alt-F11 to get the VBE (where macros live)
hit ctrl-R to see the project explorer (a lot like windows explorer)
select your project (book1) VBAProject
right click and select Insert|Class Module
Then hit F4 (to see its properties)
Change the (name) property from Class1 to WinInTaskBar

Then paste this in that code window to the right:

Option Explicit
Public WithEvents xlApp As Excel.Application
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

Now doubleclick on the ThisWorkbook object of this same project.
(you might have to expand all the levels to see it)

Paste this in the code window to the right.

Dim myWinInTaskBar As WinInTaskBar
Private Sub Workbook_Open()
   Set myWinInTaskBar = New WinInTaskBar
   Set myWinInTaskBar.xlApp = Application
End Sub
Private Sub Workbook_Close()
   Set myWinInTaskBar.xlApp = Nothing
End Sub

Now back to excel and save your workbook--but save it as an addin and store it
in your XLStart folder.

By saving it as an addin, it'll be invisible to you when you're in excel.  By
storing it in XLStart, your addin will load whenever you start excel.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

> A share workbook affects my "options/ view/ windows in task bar"
> configuration each time I open it. How can I avoid it? I have modified and
> saved this option in the share workbook but it hasn't solved the problem.

Signature

Dave Peterson

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.