Macros referance data in my spread sheet and i don't want users to tamper
with those cells, however, when I protect these cells the macro aborts siting
that the cell is protected. Is there a way to keep users out and let the
macro run?

Hi
you could first unprotect the sheet in your macro and protect the sheet
again at the end

--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
Macros referance data in my spread sheet and i don't want users to
tamper with those cells, however, when I protect these cells the
macro aborts siting that the cell is protected. Is there a way to
keep users out and let the macro run?

Thankyou for your reply, I changed the macro to clear the cells in question
and reload them as the program runs. I addition the source data cell is
protected and is updated by the spread sheet, so it can be protected.

Thank you for your help, thats a good idea any way and i will remember it
for a more complex problem in the future.

Dick

"Frank Kabel" wrote:

Hi
you could first unprotect the sheet in your macro and protect the sheet
again at the end

--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
Macros referance data in my spread sheet and i don't want users to
tamper with those cells, however, when I protect these cells the
macro aborts siting that the cell is protected. Is there a way to
keep users out and let the macro run?