Sorry, Iwas on leave so could not reply.
I have full Administrators rights.
We have win2000 with office 2000. I can do all the changes required to
the registry. In fact I have made many changes for some other purpose.

Dave,
Recording a macro during I set it does not record anything. It shows
just the sub Macro1() and End sub line.

Is there any other way around?

Regards,


"Amedee Van Gasse" wrote in message ...
Dave Peterson wrote:

If you can't get sufficient rights to update the registry, maybe you
could just record a macro while you set this.

Name your macro auto_open.
Then save that workbook in your XLStart folder.
Add this line right before the End Sub:
thisworkbook.close savechanges:=false

Then when you open excel, this workbook will open, the setting will
be changed, and the workbook will close.

Then try to find out what else you can't change and see if your IT
people can help.

Dave,
smart workaround!
I'll remember that, I often envounter clients with all their rights
stripped away.