• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Protecting Cells

J

Jeffrey Lebowski

Member
Hi All,

I have attached the file I am working on, which is designed to be used by pretty much everyone in the company.

The user selects from a dropdown in column B. I have vba that populates a 'billable rate' in column D based on this dropdown selection. I want the yellow highlighted portions to be protected so that they cannot be directly overwritten by the user. However, I need the highlighted portion to be able to change based on the column B dropdown selection.

Is there a way to accomplish this? Or do I have to unprotect>>execute code>>protect sheet again?

Thanks for your help!
 

Attachments

  • inoice template demo.xlsm
    46.4 KB · Views: 4
Hi Jeffrey ,

Your highlighted portion in column G already has formulae to do the calculation ; if you put in the necessary VLOOKUP formula in column E , along with a check to ensure that if the corresponding cell in column B is blank , then column E also remains blank , then both these columns can be protected once and for all.

Why do you want VBA to do what basic Excel formulae can do ?

Narayan
 
You must log in or register to reply here.
Back
Top