Thread: Protection
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Sisilla Sisilla is offline
external usenet poster
 
Posts: 12
Default Never Mind (Silly Me!)

The only buttons I see are for New Post and Post Reply...
and for "Never Mind" I pushed Post Reply. Please advise.
Thanks,
Sisilla


-----Original Message-----
There are three options to enter the fray:
1. New Post
2. Reply (to reply directly to the person who posted)
3. Reply Group (Replies to the group, just as you will

see this message
along with everyone else)

When a New Post is generated, it starts a "thread", which

can be recalled
and folllowed by anyone with a problem simiar to the

post. When you New
Post, (such as Silly Me!), no one will ever know that (or

how) the problem
originally presented was resolved.
--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
"Sisilla" wrote in message
...
What do you mean by:
simply Reply Group to the thread

?

Thanks,
Sisilla


-----Original Message-----
Sisilla, in the interest of keeping the thread

together,
it is best to
simply Reply Group to the thread. In that way, the

thread
can be followed to
its conclusion. By starting a new thread revealing your

Eureka! moment, no
one will see, by following the thread, that you have

found a resolution.

All the best.

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
"Sisilla" wrote in message
...
I don't know why I didn't think of this before! I

will
set
the macro to unprotect the sheet before it is run,

and
protect the sheet after it's run!

Thanks Anyway,
Sisilla


-----Original Message-----
Hello There,

My macro works fine when my sheet is unprotected,

but I
receive a prompt to debug when I protect the sheet.

I
have
unlocked the cells that have to be edited by the

macro,
so
I know that's not the problem. My macro changes the

fill
color of some cells. When I try to run it Excel

gives
me
this error:

Run-time error '1004':
Unable to set the ColorIndex property of the

Interior
class

I am prompted to debug this line of code:
Selection.Interior.ColorIndex = xlNone

I am on Excel XP, VB6.3, and Windows 2000. I

appreciate
any help.

Thnaks,
Sisilla
.



.



.