Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-18-2012, 05:42 AM
ibrahimaa ibrahimaa is offline Taskbar Windows Vista Taskbar Office 2007
Advanced Beginner
Taskbar
 
Join Date: May 2011
Posts: 35
ibrahimaa is on a distinguished road
Default 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


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" 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
Currently, the server file appears on the taskbar when the code opens it to extract the required data.

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.
Reply With Quote
  #2  
Old 02-18-2012, 01:00 PM
JBeaucaire JBeaucaire is offline Taskbar Windows XP Taskbar Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

You can turn it off/on as needed:

Code:
Application.DisplayStatusBar = False

'some code
'some code
'some code

Application.DisplayStatusBar = True
Reply With Quote
  #3  
Old 02-19-2012, 11:18 AM
ibrahimaa ibrahimaa is offline Taskbar Windows Vista Taskbar Office 2007
Advanced Beginner
Taskbar
 
Join Date: May 2011
Posts: 35
ibrahimaa is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 02-19-2012, 03:12 PM
JBeaucaire JBeaucaire is offline Taskbar Windows XP Taskbar Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

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.
Reply With Quote
  #5  
Old 02-20-2012, 10:22 AM
ibrahimaa ibrahimaa is offline Taskbar Windows Vista Taskbar Office 2007
Advanced Beginner
Taskbar
 
Join Date: May 2011
Posts: 35
ibrahimaa is on a distinguished road
Default

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.
Reply With Quote
  #6  
Old 02-20-2012, 05:58 PM
JBeaucaire JBeaucaire is offline Taskbar Windows XP Taskbar Office 2003
Advanced Beginner
 
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default

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
Reply With Quote
Reply

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
Taskbar 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
Taskbar 2 icons for outlook in taskbar? campoblanco Outlook 2 10-17-2010 06:58 PM
Taskbar Envelope in the taskbar when rules applied whatever61 Office 1 06-11-2010 09:16 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:40 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft