Form and protect sheet
in [General]
|
From: Bri on 5 Apr 2010 12:04 Hi - I have a worksheet and colleagues prefer to input data (including new data) by using the 'Data - Form'. However, if I protect the sheet (Tools - Protection - Protect Sheet), then the option to create a new record or delete an old one is grayed out in the form. Is there a way round this? I am using Excel 2003. Any advice would be appreciated. Brian.
From: Dave Peterson on 5 Apr 2010 14:15 Maybe you could provide them with a macro that Unprotects the worksheet Shows the Data|form Reprotects the worksheet. You could start by recording a macro when you do it manually. Then you could plop a button from the Forms toolbar on the sheet and assign your recorded macro to that button. Bri wrote: > > Hi - I have a worksheet and colleagues prefer to input data (including new > data) by using the 'Data - Form'. However, if I protect the sheet (Tools - > Protection - Protect Sheet), then the option to create a new record or > delete an old one is grayed out in the form. Is there a way round this? I am > using Excel 2003. > > Any advice would be appreciated. > Brian. -- Dave Peterson
From: Bri on 5 Apr 2010 16:31 Thanks Dave for the suggestion - I'll give it a whirl! Cheers, Brian. "Dave Peterson" <petersod(a)verizonXSPAM.net> wrote in message news:4BBA28AD.9E12104E(a)verizonXSPAM.net... > Maybe you could provide them with a macro that > Unprotects the worksheet > Shows the Data|form > Reprotects the worksheet. > > You could start by recording a macro when you do it manually. > > Then you could plop a button from the Forms toolbar on the sheet and > assign your > recorded macro to that button. > > Bri wrote: >> >> Hi - I have a worksheet and colleagues prefer to input data (including >> new >> data) by using the 'Data - Form'. However, if I protect the sheet >> (Tools - >> Protection - Protect Sheet), then the option to create a new record or >> delete an old one is grayed out in the form. Is there a way round this? I >> am >> using Excel 2003. >> >> Any advice would be appreciated. >> Brian. > > -- > > Dave Peterson
|
Pages: 1 Prev: sum multiple columns with SUMIF or SUMPRODUCT Next: Vlookup |