Registry syntax to ensure that an addin is opened readonly ?
 

It's been a long time since I've visited this forum where I used to be
a very frequent poster. Hi to all my old friends.

Question:
I must ensure that an addin is opened in readonly mode, by all users
except 1. This user must be able to maintain a few tables in the addin.

We've a plethore of problems since my client switched to excel 2007,
esspecially with swapping readonly/readwrite. Addin has been been
running for years all the way thru 2003. Ofcourse the client could set
RO fileattributes in explorer, but client is not too pc savvy....


I remember there's a trick with a startup switch in the registry's OPEN
entry, but can't find it.



Anyone?

Jurgen Volkerink
aka keepITcool.

Registry syntax to ensure that an addin is opened readonly ?
 

Hi KeepItCool (Jurgen)

Where have you been !

Try the \r prefix in the OPENx

\r "c:\path\myaddin"

Regards,
Peter T

"keepITcool" wrote in message
...
It's been a long time since I've visited this forum where I used to be
a very frequent poster. Hi to all my old friends.

Question:
I must ensure that an addin is opened in readonly mode, by all users
except 1. This user must be able to maintain a few tables in the addin.

We've a plethore of problems since my client switched to excel 2007,
esspecially with swapping readonly/readwrite. Addin has been been
running for years all the way thru 2003. Ofcourse the client could set
RO fileattributes in explorer, but client is not too pc savvy....


I remember there's a trick with a startup switch in the registry's OPEN
entry, but can't find it.



Anyone?

Jurgen Volkerink
aka keepITcool.

Registry syntax to ensure that an addin is opened readonly ?
 

\r "c:\path\myaddin"

Oops! That should be a forward slash

/r "c:\path\myaddin.xla"

Regards,
Peter T


"Peter T" <peter_t@discussions wrote in message
...
Hi KeepItCool (Jurgen)

Where have you been !

Try the \r prefix in the OPENx

\r "c:\path\myaddin"

Regards,
Peter T

"keepITcool" wrote in message
...
It's been a long time since I've visited this forum where I used to be
a very frequent poster. Hi to all my old friends.

Question:
I must ensure that an addin is opened in readonly mode, by all users
except 1. This user must be able to maintain a few tables in the addin.

We've a plethore of problems since my client switched to excel 2007,
esspecially with swapping readonly/readwrite. Addin has been been
running for years all the way thru 2003. Ofcourse the client could set
RO fileattributes in explorer, but client is not too pc savvy....


I remember there's a trick with a startup switch in the registry's OPEN
entry, but can't find it.



Anyone?

Jurgen Volkerink
aka keepITcool.

Registry syntax to ensure that an addin is opened readonly ?
 

Peter,

thx. That's the one i was looking for.

Re absence: I was ****ed at not getting MVP cred, which I felt I should
have received. Plus the NG was getting high on volume and low on news.

I've spent the last two years developing apps for others. Still hate
xl2007 and all it's undocumented changes in the nitty-gritty details.

So maybe I'm back... dunno yet.

Cheerz
Jurgen

--



Peter T wrote:

\r "c:\path\myaddin"

Oops! That should be a forward slash

/r "c:\path\myaddin.xla"

Regards,
Peter T


"Peter T" <peter_t@discussions wrote in message
...
Hi KeepItCool (Jurgen)

Where have you been !

Try the \r prefix in the OPENx

\r "c:\path\myaddin"

Regards,
Peter T

"keepITcool" wrote in message
...
It's been a long time since I've visited this forum where I used
to be a very frequent poster. Hi to all my old friends.

Question:
I must ensure that an addin is opened in readonly mode, by all
users except 1. This user must be able to maintain a few tables
in the addin.

We've a plethore of problems since my client switched to excel
2007, esspecially with swapping readonly/readwrite. Addin has
been been running for years all the way thru 2003. Ofcourse the
client could set RO fileattributes in explorer, but client is not
too pc savvy....


I remember there's a trick with a startup switch in the
registry's OPEN entry, but can't find it.



Anyone?

Jurgen Volkerink
aka keepITcool.