I am having a problem with something that should be simple. I am using a
excel to create a template for doing quotations. The users can edit a range
of rows but cannot edit the row with the total is (authorisation reasons). I
have tried 2 ways - one unlocking the cells that can be edited and then
protecting the sheet and secondly tried using the Allow Users to Edit Ranges
function and allowed Everyone on our network permission to edit these rows
without the usse of a password, then password protected it.
It works for me, I can edit the range of rows, but the other users cannot
(the delete/insert lines are greyed out. Then when I have tried it on a PC
not on my network I cannot edit either (via both methods).
PS I am using Terminal Server to access the network
Any ideas?

Have you saved the file as an XLT, Excel Template file?
--
Kevin Backmann


"Duncan, UK" wrote:

I am having a problem with something that should be simple. I am using a
excel to create a template for doing quotations. The users can edit a range
of rows but cannot edit the row with the total is (authorisation reasons). I
have tried 2 ways - one unlocking the cells that can be edited and then
protecting the sheet and secondly tried using the Allow Users to Edit Ranges
function and allowed Everyone on our network permission to edit these rows
without the usse of a password, then password protected it.
It works for me, I can edit the range of rows, but the other users cannot
(the delete/insert lines are greyed out. Then when I have tried it on a PC
not on my network I cannot edit either (via both methods).
PS I am using Terminal Server to access the network
Any ideas?

No a standard XLs file. It resides inside a CRM system and needs to open as
an XLS file (there are some VB codes in there that drag in contact details
from the CRM systems database)

Thanks

"Kevin B" wrote:

Have you saved the file as an XLT, Excel Template file?
--
Kevin Backmann


"Duncan, UK" wrote:

I am having a problem with something that should be simple. I am using a
excel to create a template for doing quotations. The users can edit a range
of rows but cannot edit the row with the total is (authorisation reasons). I
have tried 2 ways - one unlocking the cells that can be edited and then
protecting the sheet and secondly tried using the Allow Users to Edit Ranges
function and allowed Everyone on our network permission to edit these rows
without the usse of a password, then password protected it.
It works for me, I can edit the range of rows, but the other users cannot
(the delete/insert lines are greyed out. Then when I have tried it on a PC
not on my network I cannot edit either (via both methods).
PS I am using Terminal Server to access the network
Any ideas?