b10

I have two workbooks and I want to pull some information from one to the other depending on what the contents of the cells are. I'm trying to write a formula so that if in Cell A1 in workbook 1 says either red or amber, Cell A2 will copy information from a linked cell in another workbook, say...

Hello, I am trying to create a macro that will enable and disable the ability to save a file unless cells: B5, B10, B38 and F38 have something in them. Any ideas? Thank you!

Hello, I have a workbook that I use to choose equipment and calculate prices, and other users also uses this workbook, so it needs to be as user friendly as possible. I have then created a code that prompts a messagebox if the value in cell B10 exceeds 1. The same is done for cell B10. The...

here's what I'm aiming at: cell A1 has a drop-down list with LOCK and UNLOCK as possible choices if A1 = LOCK, then cells B1 to B10 become locked and if A1 = UNLOCK, then cells B1 to B10 become unlocked how can I make cells B1 to B10 behave thusly? thx. for any help!