Excel end user reports and preventing changes to users excel settings?
 

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

Excel end user reports and preventing changes to users excel settings?
 

but my worry is what if they terminate excel or turn off the machine
accidently before my restore code can
run.

If they close Excel your Workbook_Close code should be called so settings
can be restored. In the unlikely event that they turn the machine off you
have nothing to worry about. Excel will only write the current settings to
the registry when its exit code runs, which it will not in this case.

--
Jim Rech
Excel MVP