Yes, this is possible. What you're looking at is using the Protect Sheet functionality. Try recording a macro and Protect/unprotect a sheet. Now, are you wanting to make SURE that the user cannot modify or see the data? or just make it easier to use? If you're wanting to make SURE, then you'll have to use a password. the recorded macro will enable you to see the syntax for protect/unprotect the sheet.
Next, when a sheet is protected, it only protects "locked" cells. So, record a macro that changes the cells from locked to unlocked. Now, if you're wanting the cells to APPEAR blank, even though they have a value, then you'll want to change the fill color and font color to be the same. and the fill pattern to be solid. That way, when it prints, it will be blackened out. You basically assemble all of this into a macro, then you create a "change event" macro that tests to see if the specified cell was changed, if so, run the macro with the appropriate values. Is this enough to get you started? or do you need a more specific example? Paul ----- Original Message ---- > From: lukethegooner <lukethegoo...@gmail.com> > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > Sent: Tuesday, January 20, 2009 7:39:03 AM > Subject: $$Excel-Macros$$ Protect Cell Content on Input Result > > > Hi all! > > I'm looking to protect a number of cells, or, make them 'read only' if > you like dependant on the result of the inpurt from a certain cell. > The spreadsheet I'm composing is to be sent out to a third party for > input so I want to tie down some detail without making it look too > daunting. > > To try and put some details here, consider thus > > A B C D > 1 True 1 100 % > 2 False > > So in the above example, if the cell A1 was configured 'True' then > cells B1, C1 and D1 would behave normally and be open to edit. > > If Cell A2 is configured False, then cells B2, C2 and D2 would go > blank (or display a message) and the cells would become 'read only' / > inaccessible for edit. > > Can this be done easily in Excel? > > Luke > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---
