Re: $$Excel-Macros$$ how to lock worksheet

2013-01-04 Thread The Viper
apply the filter before protecting the sheet. select the options "use filters" in sheet protection dialogue box On Fri, Jan 4, 2013 at 3:17 PM, अनिल नारायण गवली wrote: > Dear Dhaval, > > Hide the formula bar which is availabale in options tab of workbook. > > > Thanks & Regards, > Gawli Anil > >

Re: $$Excel-Macros$$ how to lock worksheet

2013-01-04 Thread अनिल नारायण गवली
Dear Dhaval, Hide the formula bar which is availabale in options tab of workbook. Thanks & Regards, Gawli Anil On Fri, Jan 4, 2013 at 2:46 PM, Dhaval Shah wrote: > Dear friends > > i am lookking for solution 4 Lock work sheet if i am lock work sheet then > i m not able to use filter .

$$Excel-Macros$$ how to lock worksheet

2013-01-04 Thread Dhaval Shah
Dear friends i am lookking for solution 4 Lock work sheet if i am lock work sheet then i m not able to use filter actually i want to hide my formula's only is it any way to hide formula ??? Thanks Dhaval Shah -- Join official Facebook page of this forum @ https://www.facebo