How to force toolbar view options when opening and closing

Excel 2003

I want the user(s) if one file to be able to open it WITHOUT seeing task pane, formatting tool bar, Standard tool bard and any other tool bar they may have in their personal excel environment.
I want it to ONLY apply to this file
In other words when they open a new (or other existing excel document) they get all their normal tool bars.

Is this doable? and I am guessing it would be a coded solution?

Any help here will be appreciated.

Thanks in advance
duce

You can do this with VBA, but you need to be extremely careful that you reset all settings back to the original, otherwise you end up with extremely annoyed users.

OK - I have be playing around with this but not working as expected.

On the workbook OPEN

Please Login or Register  to view this content.

On workbook CLOSE

Please Login or Register  to view this content.

They do not seem to be working on the same tool bars


EDIT:
Tried this also
[code]
Application.CommandBars("Standard").Enabled = False
Application.CommandBars("Formating").Enabled = False
[\code]

What am I getting wrong?

Originally Posted by ducecoop

Well I have gone a screwed my application testing the above.

Can't seem to get the formatting tool bar back.

Can someone please tell me how to code this correctly
AND
turn them back on correctly

This is the reason that I would recommend you don't do this

Here's an example, but use at your own risk

Dictator Application