protecting a worksheet

  • Thread starter Thread starter HSalim[MVP]
  • Start date Start date
H

HSalim[MVP]

I have a worksheet that is is being proteted in code - in the workbook open
event.
This was working well till recently - Users could only click on the cells
that were unprotected.

Now, users can click on any cell. What have I done wrong?

Thanks in advance for your advice

Habib
 
Hi Habib,

'---------------
I have a worksheet that is is being proteted in code - in the workbook open
event.
This was working well till recently - Users could only click on the cells
that were unprotected.

Now, users can click on any cell. What have I done wrong?
'---------------

Post the protection code.
 
Thanks! that should do it - I'll try it tonight and post an update
Regards
Habib

--
www.DynExtra.com
A resource for the Microsoft Dynamics Community
Featuring FAQs, File Exchange and more
Current member count: 40
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protecting worksheet. 1
Excel Protection 2
How to bypass password when pasting FROM a protected workbook 3
Controlling worksheet protection via VBA 0
Worksheet protection 2
Copying in sheet with protection with the use of a macro 5
protecting the entire worksheet 3
Sorting a protected worksheet 1

Back
Top