How to force toolbar view options when opening and closing

[ducecoop]

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

[royUK]

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.

[ducecoop]

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.

I understand - Kinda like "Set warnings" in Access.

Can you tell me how to turn them off at opening
and
how to turn them back on at closing

Thanks

[ducecoop]

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

On the workbook OPEN

  
 Application.CommandBars(2).Enabled = False
   Application.CommandBars(3).Enabled = False
   Application.CommandBars(4).Enabled = False

On workbook CLOSE

    Application.CommandBars(2).Enabled = True
    Application.CommandBars(3).Enabled = True
    Application.CommandBars(4).Enabled = True

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?

[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

[royUK]

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

[royUK]

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

Dictator Application

[ducecoop]

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

Dictator Application

Thank you
I will give it a try