I want to create some excel reports for our fiels users. I plan on
sending them a monthly spread sheet with 5 report tabs with their
sales data.
I have looked at crystal reports but see nothing in Crystal that I
can't do better in excel. I need graphs and the ability to click on
names and have charts change on the fly.
My question is, can I make changes to excel (Full screen, remove
menus) that will not impact the users excel next time they open it.
I know I can make these changes in VB code and then change it back
when they exit my excel app but my worry is what if they terminate
excel or turn off the machine accidently before my restore code can
run. Then the next time they run excel the fullscreen and menus will
be wrong.
I don't want to screw uptheir excel settings, but want they a certain
way when my workbook is loaded.
Any help would be appreciated.

Georgia Mankester