Excel Templetes?

  • Thread starter Thread starter Kevin Chan
  • Start date Start date
K

Kevin Chan

Hi

Do anyone know is there something like Normal.dot in
excel? We are using terminal services here, but we have
problems to keep users custom setings, like when a user
change something and would like to make the changes as
default, everytime when the user log out, the changes
gone.

Anyone has any idea?
 
Excel doesn't have the same kind of file as word has with normal.dot.

Excel does have a couple of files (personal.xls and book.xlt) that contain
macros and default layout for new workbooks. But neither of these contain the
settings that you want (I think???).

In excel, these settings are kept in the Windows Registry or even with the
workbook itself.

I've never used terminal services, so I'm not sure how this fits in--or ways
around it.

Well, one way around it might not be worth the trouble.

Record a macro when you change the settings you want.

Clean up that macro to do only the things you want reset.

Add one line at the bottom:

thisworkbook.close savechanges:=false

Name that subroutine auto_open.

Save that workbook in your XLStart folder.

Now everytime you open excel, this workbook will open and change the settings.
And the last line will close the workbook after it's finished working.

(All that said, I'm not sure if any of this is possible with Terminal Services
stuff.)
 
Back
Top