Good afternoon.
sorry to bother again. but will you can help me. is that I am trying to format a group of cells, as follows.
if C17 contain a value, free from the E17 cell to AI17 in order to get access to write.
and this format would be equal from C17 to C167.
Last edited by Birnen; 09-15-2010 at 10:42 AM.
Let me be the first to say..."Huh?"
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
[QUOTE=Birnen;2382735]Good afternoon.
sorry to bother again. but will you can help me. is that I am trying to format a group of cells, as follows.
if C17 contain a number, unprotect the range from, E17 cell to AI17, in order to get access to write.
and this format would be equal from C17 to C167.
1) Put this macro into the ThisWorkbook module, edit it to refer to the correct sheet and the correct password.
Please Login or Register to view this content.
Even though the sheet is protected, setting the UserInterfaceOnly flag when the workbook opens allows VBA to make changes to the sheet without protecting/unprotecting over and over.
2) Place this macro into the Sheet module:
Please Login or Register to view this content.
As you work on the sheet, if you place a number into any cell in range C17:C167, that row will be unlocked. Happens in realtime.
Last edited by JBeaucaire; 09-20-2010 at 06:21 PM.
Originally Posted by JBeaucaire
1) Put this macro into the ThisWorkbook module, edit it to refer to the correct sheet and the correct password.
Please Login or Register to view this content.
Even though the sheet is protected, setting the UserInterfaceOnly flag when the workbook opens allows VBA to make changes to the sheet without protecting/unprotecting over and over.
2) Place this macro into the Sheet module:
Please Login or Register to view this content.
As you work on the sheet, if you place a number into any cell in range C17:C167, that row will be unlocked. Happens in realtime.
give me error in IsNumeric...
This is less secure as people can copy and paste items in but if they are manually entering data, you can use Data Validation to protect those cells.
Select E17:AI167, then go to Data Validation>Custom
Uncheck "Ignore blanks"
enter =LEN($C17)>0 ENTER
Type in an appropriate Error Alert "Column C must be filled in first."
Hit OK
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I've edited macro #2 above to try and resolve that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks