#1
|
|||
|
|||
Taskbar
I have the following code in a macro that open a server file, extract specific data and locate it in the this user file.
HTML Code:
Sub getvalue() Dim Path, myrange, ShName, Wb As String Path = "\\Server Folder" Wb = "Report-1c-Server.xlsx" myrange = "A9:C9700" Workbooks.Open Filename:=Path & "\" & Wb Although, the server file is not editable, is there a way to not make it appear on the taskbar ( hid it)? I appreciate your support. Thank you. |
#2
|
|||
|
|||
You can turn it off/on as needed:
Code:
Application.DisplayStatusBar = False 'some code 'some code 'some code Application.DisplayStatusBar = True |
#3
|
|||
|
|||
Thanks a lot for the support. However, I have placed it in different places (below is just examples) and still does not work where the server file still appears in the below taskbar.
Also, I found that you can click on the server file while it is appearing in the taskbar and views its content which I do not want the user to do. I would highly appreciate any further help. Thank you. Code:
Sub getvalue() Dim Path, myrange, ShName, Wb As String Path = "\\Server Folder" Wb = "Report-1c-Server.xlsx" myrange = "A9:C9700" Workbooks.Open Filename:=Path & "\" & Wb Application.DisplayStatusBar = False With ThisWorkbook.Sheets("EXHIBIT 6-A") 'change sheet1 to your sheet name .Activate Select Case ThisWorkbook.Sheets("EXHIBIT 6-A").Cells(5, "S") Case 7 ShName = "Arxxx-MP-July" Application.DisplayStatusBar = False ActiveSheet.Cells(7, "B") = Application.VLookup(ActiveSheet.Cells(4, "G"), Workbooks(Wb).Sheets(ShName).Range(myrange), 3, False) Case Else End Select End With Workbooks(Wb).Close , savechanges = True End Select End Sub |
#4
|
|||
|
|||
Odd, have you tried completely turning off screenupdating, too?
Code:
Sub MyMacro() Application.ScreenUpdating = False Application.DisplayStatusBar = False 'some code 'some code 'some code Application.DisplayStatusBar = True Application.ScreenUpdating = True End Sub This should be necessary except once at the top and once at the bottom to turn it back to normal. |
#5
|
|||
|
|||
Thanks a lot for your great support. Now I cannot maximize the file and browse its content but it still appear in the taskbar as icon with its name.
|
#6
|
|||
|
|||
You're talking about the WINDOWS Taskbar? Not the Excel Statusbar? Maybe what you need is:
Code:
Application.DisplayFullScreen = True If not, try this: http://www.vbaexpress.com/kb/getarticle.php?kb_id=54 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Show all windows in taskbar option for PP 2010. | WLVanS | PowerPoint | 10 | 02-11-2012 01:32 AM |
Show all windows in the Taskbar - problem | binaryfinary | Word | 1 | 06-14-2011 03:51 PM |
Taskbar .doc disappeared | Ossum | Word | 0 | 12-05-2010 12:53 AM |
2 icons for outlook in taskbar? | campoblanco | Outlook | 2 | 10-17-2010 06:58 PM |
Envelope in the taskbar when rules applied | whatever61 | Office | 1 | 06-11-2010 09:16 PM |