how to disable protected sheet cell massage on VBA protect code

[Lukma]

Hi Friends

i have a VBA code to protect my data so that no one will be able to copy or paste or edit whenever i send to someone,
All i need is to view only they wont be able to copy or edit or paste. but i don't wont protected massage to pop up whenever then click or try to copy or edit to show.

Please is there any better VBA solution to protect my data from been copy or paste or edit and that will not pup up warning massage

appreciate if anyone can help out with a better VBA code that can protect my Sheet from been copy or paste or edit and to disable warning massage to make it more nice

thanks

 

[yky]

Can you protect your sheet using the menu option Review/Protect Sheet? Lock the cells you don't want people to copy. Then, protect the sheet and uncheck "Select locked cells". So, people can't select them and, thus, can't copy them. Just remember Excel's protection is weak. It can be easily broken.

 

[Lukma]

thanks but still is there a way to stop massage from pup up like this if there is a solution to disable it will be more helpful

 

[yky]

I don't see that message on my protected sheets. What is the VBA doing?

 

[Jaafar Tribak]

thanks but still is there a way to stop massage from pup up like this if there is a solution to disable it will be more helpful



View attachment 30216

There is no easy way.

I remember being able to stop that message but I had to use a windows timer or install a windows hook. However, both methods are better avoided unless absolutely necessary and used only temporarly during code life-time.

I would follow yky advise.

 

[Zot]

Hi Friends

i have a VBA code to protect my data so that no one will be able to copy or paste or edit whenever i send to someone,
All i need is to view only they wont be able to copy or edit or paste. but i don't wont protected massage to pop up whenever then click or try to copy or edit to show.

Please is there any better VBA solution to protect my data from been copy or paste or edit and that will not pup up warning massage

appreciate if anyone can help out with a better VBA code that can protect my Sheet from been copy or paste or edit and to disable warning massage to make it more nice

thanks

You can just simply uncheck Select Locked Cells when asking for password to protect sheet. This way viewer cannot click the cell and no message

 

[yky]

You can just simply uncheck Select Locked Cells when asking for password to protect sheet. This way viewer cannot click the cell and no message

That's the method I suggested to OP.

 

[Zot]

That's the method I suggested to OP.

I noticed that after I replied ?

Anyway, what is OP meant in this forum? Not familiar

 

[MARK858]

Anyway, what is OP meant in this forum? Not familiar

Original Poster (or occasionally people use it for original post).

 

[Lukma]

Thanks Guys for your message