Excel - Programmatically Disable Taskbar
Asked By StephenLloy
21-Oct-08 03:00 PM
I've created an Add-In application that loops through files and tests the
value in a range in each file. Then it sends an email if the number doesn't
balance. There could be up to 40-50 files with any number of files having an
error. I've naturally set .ScreenUpdation = False.
I'm wondering if there is a way to temporarily disable the taskbar to
prevent each workbook from being placed on the taskbar and then removed each
time the loop iterates.
I have found code at the link below to hide and unhide the taskbar using API
calls, however, I'm wondering if, 1) even though it is hidden, it is still
updating? and 2) would the property values for toggling the taskbar window
have changed from Windows 98 to Windows 2k3? (I highly doubt they would have
changed.)
http://support.microsoft.com/default.aspx?scid=kb;en-us;290150
Application.ShowWindowsInTaskbar
(1)
Workbook
(1)
ViewUncheck
(1)
ProblemTools
(1)
Window
(1)
Smarts
(1)
Scid
(1)
Peter T replied...
There's a much simpler way to avoid the problem
Tools, Options, View
Uncheck "Windows in Taskbar"
I really don't know why it's enabled by default
In code
Application.ShowWindowsInTaskbar = False
If you are doing that for other users store the setting first and reapply
when done.
It's n/a in xl97, if necessary cater appropriately to avoid error
Regards,
Peter T
StephenLloy replied...
Thank you very much! Even though it smarts, I love when things are simpler
than I tend to make them.
I will try it out.
User Defined Function being called by changes to an independent workbook Excel Excel 97 Hi, we have a Workbook originally developed by my company's Actuarial depar = tment to validate results for our bespoke application. This workbook, contains numerous worksheets containing lookup tables, and c = alculations, some of which are User Defined added to our application and are verified by a corr = esponding updated version of the workbook. = 20 This year the Workbook has manifested a strange behaviour of calling one th = e User Defined functions when changes are made to an independent workbook o = pened in the same session of Excel. eg, open testing workbook, enter data e = verything is fine calcualations work, open a new workbook or existing workb = ook and when modifications are made to that it is apparent that
by double click Excel Hi, I need a macro to list all sheets in a workbook and be able to select from the list by double clicking the name of the fGoToSheet.ListBox1.AddItem Sheets(i).Name Next 'i fGoToSheet.Show End Sub In the code window behind a userform named "fGoToSheet": Option Explicit Private Sub CommandButton1_Click() Unload Me End Sub Private click Insert / UserForm form the menu bar. You will see a blank form and a window with the caption Toolbox. The Toolbox has controls (TextBox, ListBox, etc.) on it that you let us rename it. On the left side of the VB editor should be a window with the caption "Properties - UserForm1" (if you do not see this, press F4). The first field of the Properties window is labeled (Name) and next to it is the word UserForm1. . . click the word UserForm1 can click / drag it to any position you want, but we will use the Properties window to set them to exact values. There are only seven properties I want you to set initially. In the Properties window, find and set the following values. . . Height = 18 Left = 10 MultiLine = True Top = 10 Width on the UserForm to place it. Set the following properties for it in the Properties window. . . Height = 165 Left = 10 Top = 38 Width = 140 Okay, that should take care of setting
Closing Help Window From Keyboard Excel it is very common in Excel that you go to hit F2 to switch to mouse to close it. Is there a keystroke to close that help window? - - W Excel Miscellaneous Discussions Microsoft Excel (1) Office 2003 (1) Excel 2010 (1) Excel 2003 Classic Menu . . .) you forced help That closes Excel. I only want to close the child window that the Help facility lives in. - - W Wonderful, thank you! - - W you forced help Am in every language version. In my german language version Alt + F4 only closes the help window Regards Claus Busch - - Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 / 2007 Ultimate close program" key combination. And yes, I checked it before posting. It closes the help window but not Excel. - - Stan Brown, Oak Road Systems, Tompkins County, New York, USA http: / / OakRoadSystems Gord Gord Dibben explained : When Help appears in a docked pane (rather than its own window), Ctrl+F1 closes the Help pane while Alt+F4 closes the host app because its window has the focus. When Help appears in its own window, Alt+F4 closes the Help window IF it has the focus. IOW, Alt+F4 closes
Open UserForm From A Different Workbook Excel Greetings, I have two workbooks, Workbook1 (The customer list) and Workbook2 (a monthly data Programming Discussions WhichWkbkCalledMe.FullName (1) Office 2003 (1) Excel 2007 (1) Sheets (1) Worksheet (1) Workbook (1) Macro (1) XP (1) Is the recordform just a userform? Maybe you can separate all the code (userform and module1's) into a 3rd workbook. Make this new code only workbook an addin. Tell the users that they have to load the addin to make any not sure how you use it. So you would only need 2 workbooks- -the macro workbook and the data workbook. But after you have separated the code from the workbook, you will have to give the users a way to run your macros (get to worksheet menu bar, I really like the way John Walkenbach does it in his menumaker workbook: http: / / j-walk.com / ss / excel / tips / tip53.htm Here is how I do it
there is more than one name to be added. NOTE: The boss will be in workbook(QA Master.xls) Once the boss is through entering names, the macro will then loop and create a workbook, copying the Workbook("QA Template.xls") and renaming it with the employee name that was entered. I do I am getting the following error on the line that copies and names the new workbook: Runtime Error 9 Subscript Out of Range The macro is below: Option Base 1 'Add Employee to list and create workbook for employee Private Sub CommandButton2_Click() Dim Employee(1 To 200), Msg, Title As String 'Array Msg, Config, Title) If Ans2 = vbYes Then num = num + 1 GoTo ADDEMP End If 'Create workbook for each employee entered For k = 1 To num Workbooks("QA Template.xls").SaveAs Filename Les Excel Programming Discussions Excel 2007 (1) Sheets (1) Office (1) Error (1) Worksheet (1) Workbook (1) Module (1) Macros (1) Subscript out of range means that there is nothing by SaveAs _ Filename: = myPath & " \ " & Employee(k) & ".xls" Next k will save the "QA template.xls" workbook with a new name. That means that there is no longer an open workbook with