On Thursday, December 10, 2009 12:29:52 PM UTC+5:30, punit poddar wrote: > > Hi > > The above file will be used by two person - User and the Administrator, > administrator can edit anywhere, while the user can edit only in the range > specified, based on this I have done something in the file attached but > would help you guys to pls help. Please find attached the excel file. > > 1. Form that will be used to unlock only the current sheet, it will be > better if we give the user option to change the password. > 2. On closing the file the sheet will automatically gets locked. > 3. Have give the user the option to edit only a small range of cells. > > Regards > Punit >
-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
