Excel format settings for multiple users??

Hi there,

I have created an excel sheet that i have locked and protected so end users cant screw it up basically. But i have it formatted nicely on my screen (i.e. i have removed unecessary toolbars/formula bar etc) so it looks tidy. But as soon as another user opens it up on their PC, all the toolbars etc keep reappearing and it looks very untidy again. Im guessing this is down to each user's preference on how they like to work in excel, but is there anyway you can customise this so you get a standard view for all users????

Would this perhaps be in the module code or something like that??

Many Thanks!

Tom

Hello Tom,

Please re-read the forum rules regarding duplicate postings. You asked the same question in the Miscellaneous group. I have locked that post. http://www.excelforum.com/showthread.php?t=624810

Sincerely,
Leith Ross

Roy thanks,

But i have added a custom toolbar to my project - how will i know if it will display everytime when the users open the workbook on their PCs?