PDA

View Full Version : HELP CODE in VBA



archana
11-30-2006, 02:29 AM
how to make other sheets read only and still transfer entries from the main sheet into sub-sheets in an excel workbook.Is there any code to prevent users from modifying the data once entered.

ilyaskazi
11-30-2006, 02:33 AM
why don't you use menu: Tools -> Protection -> Protect Sheet...
Use macro recorder if you need codes.

johnske
11-30-2006, 02:36 AM
If you mean to allow transfer of data by VBA but stop any manual entries, just protect the sheet and put ActiveSheet.UnProtect at the head of any code and ActiveSheet.Protect at the end of it :)

archana
12-01-2006, 05:17 AM
it is not working iam getting error 1004

johnske
12-01-2006, 05:52 AM
Remaove any sensitive data and attach the workbook so someone can look at what you've done...

OBP
12-01-2006, 05:53 AM
archana, can you post your code to help johnske and others to understand what is going wrong please?