Not to reinvent the wheel

[Pete]

I don't want to reinvent the wheel. But here is what I want to do. When my
workbook opens I would like it to store the users default setups for excel.
Then I want to change the users setups for the session. Then upon, when the
users exits from my session reinstate the users preferences to their
original setup.

Somebody has got to have done this before.

Someone please point me in the right direction.

Thanks

 

[kkknie]

Use the macro recorder to change them to the new settings, then chang
them back. This should give you everything you need.

Create a sheet to hold them and when you start excel, write the value
to the sheet and when you exit, write them back to excel.

 

[Tom Ogilvy]

There are hundreds of setups. I would expect you know which ones you want
to change, so you can turn on the macro recorder while you change them to
get the objects and properties.

Then place the settings in a hidden sheet in the workbook_open event and
restore them in the workbook_beforeclose event. You might also write a
textfile with the settings and delete it when they are restored. Then you
can provide a workbook that will read the textfile and restore the settings
in the event a crash has left the user with lost settings.