View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dago Dago is offline
external usenet poster
 
Posts: 1
Default hide TASKBAR in Sub Workbook_open()

Hi,

I have an Excel application that hides all bars

With ActiveWindow
.DisplayHeadings = False
.DisplayOutline = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
End With

but: I want the Windows TASKbar hidden as well to get a real ful
screen view.
I want it to work in Windows 98, 2000 and XP and with Excel 97, an
2000

The code should be in the Sub Workbook_open() in the ThisWorkBoo
VBAProject in Excel

I've tried several pieces of code, which produce errors.

Is there a piece of code that I can use to hide the Windows taskba
automatically upon opening the excel file?

This code would be appreciated! If you're willing to help, pleas
provide some instructions, as I am a relative novice...

Thanks in advance!

Dag

--
Message posted from http://www.ExcelForum.com