On a Public Network Drive at my company I have been building several
workbooks with knowledge gratefully scavenged from this forum for the
purposes of recording training processes. But I have now encountered some
problems I cannot resolve.

Using Chip Pearson's website, I have created an Add In which returns the
Cell Color Index. This works fine untill I open the workbook from another
computer when it has problems locating the Add In.

Even when I Browse/ Select the specific one, it says the "unable to copy
into library" and in the cells which used to have the formula
"=cellcolorindex(A1,False)" now gives a definition of where the Add In it
cant find should be [drive\folder\name\etc].

Does anyone know how I can rectify this?

Thanks in advance for your help

Each computer needs to have it's own copy of the addin. Once one computer
accesses the addin it locks the addin from being used by any other computer.
At one company I worked for we had a template that we used to allow users to
select the addins that they wanted and it would copy the addins from the
network to a local directory on their machine and installed the addin for
them. Just a thought...
--
HTH...

Jim Thomlinson


"Phin Doyle" wrote:

On a Public Network Drive at my company I have been building several
workbooks with knowledge gratefully scavenged from this forum for the
purposes of recording training processes. But I have now encountered some
problems I cannot resolve.

Using Chip Pearson's website, I have created an Add In which returns the
Cell Color Index. This works fine untill I open the workbook from another
computer when it has problems locating the Add In.

Even when I Browse/ Select the specific one, it says the "unable to copy
into library" and in the cells which used to have the formula
"=cellcolorindex(A1,False)" now gives a definition of where the Add In it
cant find should be [drive\folder\name\etc].

Does anyone know how I can rectify this?

Thanks in advance for your help

Hi Jim, thanks for the speedy reply.

Just to clarify: if I create a blank spreadsheet with the Add In active
within it, then save this as a template other users can have access to it?
Will they need to save it under an individual name?

Once this is done, is it then possible for the Add In (which returns cell
color indexes- if that makes a differance) to be used on other (already
created) spreadsheets opened from the same machine?

"Jim Thomlinson" wrote:

Each computer needs to have it's own copy of the addin. Once one computer
accesses the addin it locks the addin from being used by any other computer.
At one company I worked for we had a template that we used to allow users to
select the addins that they wanted and it would copy the addins from the
network to a local directory on their machine and installed the addin for
them. Just a thought...
--
HTH...

Jim Thomlinson


"Phin Doyle" wrote:

On a Public Network Drive at my company I have been building several
workbooks with knowledge gratefully scavenged from this forum for the
purposes of recording training processes. But I have now encountered some
problems I cannot resolve.

Using Chip Pearson's website, I have created an Add In which returns the
Cell Color Index. This works fine untill I open the workbook from another
computer when it has problems locating the Add In.

Even when I Browse/ Select the specific one, it says the "unable to copy
into library" and in the cells which used to have the formula
"=cellcolorindex(A1,False)" now gives a definition of where the Add In it
cant find should be [drive\folder\name\etc].

Does anyone know how I can rectify this?

Thanks in advance for your help

Not quite. You have your addin stores on a network drive somewhere. What you
want to do is to create a template spreadsheet that does one thing only and
that is to copy the addin from the network and paste is somewhere on their
local machine. In the grander scheme of things it just copies and pastes
files from the network directory to your local directory. Once it copies the
addin to the local machine it can then install that addin pointin at the file
on the local machine...
--
HTH...

Jim Thomlinson


"Phin Doyle" wrote:

Hi Jim, thanks for the speedy reply.

Just to clarify: if I create a blank spreadsheet with the Add In active
within it, then save this as a template other users can have access to it?
Will they need to save it under an individual name?

Once this is done, is it then possible for the Add In (which returns cell
color indexes- if that makes a differance) to be used on other (already
created) spreadsheets opened from the same machine?

"Jim Thomlinson" wrote:

Each computer needs to have it's own copy of the addin. Once one computer
accesses the addin it locks the addin from being used by any other computer.
At one company I worked for we had a template that we used to allow users to
select the addins that they wanted and it would copy the addins from the
network to a local directory on their machine and installed the addin for
them. Just a thought...
--
HTH...

Jim Thomlinson


"Phin Doyle" wrote:

On a Public Network Drive at my company I have been building several
workbooks with knowledge gratefully scavenged from this forum for the
purposes of recording training processes. But I have now encountered some
problems I cannot resolve.

Using Chip Pearson's website, I have created an Add In which returns the
Cell Color Index. This works fine untill I open the workbook from another
computer when it has problems locating the Add In.

Even when I Browse/ Select the specific one, it says the "unable to copy
into library" and in the cells which used to have the formula
"=cellcolorindex(A1,False)" now gives a definition of where the Add In it
cant find should be [drive\folder\name\etc].

Does anyone know how I can rectify this?

Thanks in advance for your help

Right so.

Thanks for your help, I'll give it a go

Thanks again

"Jim Thomlinson" wrote:

Not quite. You have your addin stores on a network drive somewhere. What you
want to do is to create a template spreadsheet that does one thing only and
that is to copy the addin from the network and paste is somewhere on their
local machine. In the grander scheme of things it just copies and pastes
files from the network directory to your local directory. Once it copies the
addin to the local machine it can then install that addin pointin at the file
on the local machine...
--
HTH...

Jim Thomlinson


"Phin Doyle" wrote:

Hi Jim, thanks for the speedy reply.

Just to clarify: if I create a blank spreadsheet with the Add In active
within it, then save this as a template other users can have access to it?
Will they need to save it under an individual name?

Once this is done, is it then possible for the Add In (which returns cell
color indexes- if that makes a differance) to be used on other (already
created) spreadsheets opened from the same machine?

"Jim Thomlinson" wrote:

Each computer needs to have it's own copy of the addin. Once one computer
accesses the addin it locks the addin from being used by any other computer.
At one company I worked for we had a template that we used to allow users to
select the addins that they wanted and it would copy the addins from the
network to a local directory on their machine and installed the addin for
them. Just a thought...
--
HTH...

Jim Thomlinson


"Phin Doyle" wrote:

On a Public Network Drive at my company I have been building several
workbooks with knowledge gratefully scavenged from this forum for the
purposes of recording training processes. But I have now encountered some
problems I cannot resolve.

Using Chip Pearson's website, I have created an Add In which returns the
Cell Color Index. This works fine untill I open the workbook from another
computer when it has problems locating the Add In.

Even when I Browse/ Select the specific one, it says the "unable to copy
into library" and in the cells which used to have the formula
"=cellcolorindex(A1,False)" now gives a definition of where the Add In it
cant find should be [drive\folder\name\etc].

Does anyone know how I can rectify this?

Thanks in advance for your help

As I recall the only trick was that you need to uninstall old versions of the
addin before you can overwrite the addin file on the local machine. So the
flow of the program is:

Attempt to uninstall the addin on the local machine
Copy the addin from the network to the local machine
Install the addin on the local machine...
--
HTH...

Jim Thomlinson


"Phin Doyle" wrote:

Right so.

Thanks for your help, I'll give it a go

Thanks again

"Jim Thomlinson" wrote:

Not quite. You have your addin stores on a network drive somewhere. What you
want to do is to create a template spreadsheet that does one thing only and
that is to copy the addin from the network and paste is somewhere on their
local machine. In the grander scheme of things it just copies and pastes
files from the network directory to your local directory. Once it copies the
addin to the local machine it can then install that addin pointin at the file
on the local machine...
--
HTH...

Jim Thomlinson


"Phin Doyle" wrote:

Hi Jim, thanks for the speedy reply.

Just to clarify: if I create a blank spreadsheet with the Add In active
within it, then save this as a template other users can have access to it?
Will they need to save it under an individual name?

Once this is done, is it then possible for the Add In (which returns cell
color indexes- if that makes a differance) to be used on other (already
created) spreadsheets opened from the same machine?

"Jim Thomlinson" wrote:

Each computer needs to have it's own copy of the addin. Once one computer
accesses the addin it locks the addin from being used by any other computer.
At one company I worked for we had a template that we used to allow users to
select the addins that they wanted and it would copy the addins from the
network to a local directory on their machine and installed the addin for
them. Just a thought...
--
HTH...

Jim Thomlinson


"Phin Doyle" wrote:

On a Public Network Drive at my company I have been building several
workbooks with knowledge gratefully scavenged from this forum for the
purposes of recording training processes. But I have now encountered some
problems I cannot resolve.

Using Chip Pearson's website, I have created an Add In which returns the
Cell Color Index. This works fine untill I open the workbook from another
computer when it has problems locating the Add In.

Even when I Browse/ Select the specific one, it says the "unable to copy
into library" and in the cells which used to have the formula
"=cellcolorindex(A1,False)" now gives a definition of where the Add In it
cant find should be [drive\folder\name\etc].

Does anyone know how I can rectify this?

Thanks in advance for your help