Short Tips#0074: Protect only some cells in whole sheet
Lesson#121: How to make some cells unprotected when protecting a sheet
OK, I am having a sheet here which calculates the age when the birth date is provided. I need to protect the sheet before giving it to users. So none of them change the structure or formula. But I also …
Lesson#121: How to make some cells unprotected when protecting a sheet Read more »
Lesson#120: What is Input Box in VBA?
What is an Input Box? In VBA Input Box is a function that allows you to request information from the user who can type it in a text field of a dialog box. The basic syntax of this function is: …
Lesson#119: What is a Message Box in VBA?
What is a Message Box? A message box is a special dialog box used to display a piece of information to the user. The user cannot type anything in the message box. There are usually two kinds of message boxes …
Lesson#118: Format only cells that contain Conditional Formatting
Have you seen this Conditional Formatting option – Format only cells that contain? If not then you must remember that this option makes many works of yours easier with Conditional Formatting. Then you need to go to Conditional Formatting>New Rule Then …
Lesson#118: Format only cells that contain Conditional Formatting Read more »