Macro Needed For This !!

[cassy01]

When i open a workbook I need a macro to automatically get rid of the:

Standard Toolbar
Format Toolbar
Drawing Toolbar
Formula Bar
Status Bar
Row & Column Headers
Sheet Tabs


and then on sheet1 called 'ADD' - this needs no scroll bars
and on sheet2 which is called 'MARKS' - this needs scroll bars

then when I close the workbook it puts everything back.

Many Thanks
Benn

p.s can you also tell me how to get rid of these so that if i need t
edit it i can.

thanks again. :

 

[BrianB]

I suggest you record a macro whilst doing the job manually and come bac
with probs