Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automate unprotecting of blank cells
I have a spreadsheet that has several cells with values entered into it. I want others to add some values, but I don't want them to change cells that already have values. I know that I can use goto, special, constants and protect those cells. Can someone recommend a macro or method to review each cell within a specified range and unprotect it if it is blank? Any suggestions would be appreciated. Jim Palmer -- Jim Palmer ------------------------------------------------------------------------ Jim Palmer's Profile: http://www.excelforum.com/member.php...fo&userid=5210 View this thread: http://www.excelforum.com/showthread...hreadid=466861 |
#2
|
|||
|
|||
Record a macro when you select your range
Edit|goto|special|but click blanks then format|cells|protection tab|uncheck Locked Jim Palmer wrote: I have a spreadsheet that has several cells with values entered into it. I want others to add some values, but I don't want them to change cells that already have values. I know that I can use goto, special, constants and protect those cells. Can someone recommend a macro or method to review each cell within a specified range and unprotect it if it is blank? Any suggestions would be appreciated. Jim Palmer -- Jim Palmer ------------------------------------------------------------------------ Jim Palmer's Profile: http://www.excelforum.com/member.php...fo&userid=5210 View this thread: http://www.excelforum.com/showthread...hreadid=466861 -- Dave Peterson |
#3
|
|||
|
|||
Thanks Dave I was looking for "blanks" on the go to special screen, however I didn't notice it. Thanks for your help. Jim My new glasses arrive at the end of the week. -- Jim Palmer ------------------------------------------------------------------------ Jim Palmer's Profile: http://www.excelforum.com/member.php...fo&userid=5210 View this thread: http://www.excelforum.com/showthread...hreadid=466861 |
#4
|
|||
|
|||
LensCrafters--glasses in an hour!
<vbg Jim Palmer wrote: Thanks Dave I was looking for "blanks" on the go to special screen, however I didn't notice it. Thanks for your help. Jim My new glasses arrive at the end of the week. -- Jim Palmer ------------------------------------------------------------------------ Jim Palmer's Profile: http://www.excelforum.com/member.php...fo&userid=5210 View this thread: http://www.excelforum.com/showthread...hreadid=466861 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot tables reports - altering display of (blank) cells | Excel Worksheet Functions | |||
How can I replace a range of blank cells with a 0 | Excel Discussion (Misc queries) | |||
Copy down - special to fill only the blank cells | Excel Discussion (Misc queries) | |||
blank cells | Excel Discussion (Misc queries) | |||
What function can make cells shift up when they are blank? | Excel Worksheet Functions |