Locking Excel view

[nightguy]

Hi, following up to my post yesterday (thanks for everyone who had a look), I have a related problem.

I'd like to lock the view of an excel sheet so that any user who opens the file will see exactly the same thing on screen, whatever their excel settings are. ie I want to remove all the toolbars, formulae, and I want it to load in full screen mode. Furthermore, I don't want anyone to be able to change these settings as long as they're viewing my excel sheet.

Can anybody help???

 

[Andrew Poulsom]

That's asking quite a lot and you will need VBA to do it.

Here's a link that might get you started:

http://www.tek-tips.com/gfaqs.cfm/lev2/4/lev3/32/pid/707/fid/1572