Hi all,

Ok, I posted a request to ask for the code to remove the task bar in Excel 2010. After searching through Google I have finally found one that works, however you need to go into the VBA Project and click Run for it to activate.

Can anyone help to automate this when the sheet is opened?

The code starts as follows, what do I need to enter above this to automate it?

Option Explicit

Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" _
(ByVal lpClassName As String, ByVal lpWindowName As String) As Long

Many thanks,

Andy.