Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking rows or Regions in Excel worksheets
Hello,
Is there a way to run a macro to 'lock' a row or region in an Excel worksheet once a user has entered data into that row or region (perhaps once the user clicks on the 'Save' button)? I've looked at 'Tools... Protection... Protect Sheet... ', but I'm not sure if this quite does the trick. I have some great code to lock records in Access using some good Forms coding, so that all the different types of controls (Text boxes, combo boxes, etc.) get locked once the record is saved, but is there a way to do this for a raw Excel table? Thanks. -- Pat Dools |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying multiple rows to other worksheets (but amount of rows varies) - How? | Excel Discussion (Misc queries) | |||
How do you protect hidden linked worksheets with in an Excel workb | Excel Discussion (Misc queries) | |||
Sort rows across multiple worksheets - Excel 2003 | Excel Worksheet Functions | |||
How do I find duplicate rows in a list in Excel, and not delete it | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) |