Re: $$Excel-Macros$$ Re: Restrict cell format not values

2011-10-22 Thread Ayush Jain
Hi Sam, Thank you so much. It worked well for me. Cheers. Regards Ayush Jain On Fri, Oct 21, 2011 at 4:47 PM, GoldenLance wrote: > Here's a link too > > http://excelhints.com/2008/10/21/protect-cell-formats/ > > Regards, > > Sam > > On Oct 21, 3:06 pm, GoldenLance wrote: > > Please protect t

$$Excel-Macros$$ Re: Restrict cell format not values

2011-10-21 Thread GoldenLance
Here's a link too http://excelhints.com/2008/10/21/protect-cell-formats/ Regards, Sam On Oct 21, 3:06 pm, GoldenLance wrote: > Please protect the sheet, and use 'Allow Users To Edit Ranges' option. > Your format will remain, and users will not be able to edit, but you > will be able to add dat

$$Excel-Macros$$ Re: Restrict cell format not values

2011-10-21 Thread GoldenLance
Please protect the sheet, and use 'Allow Users To Edit Ranges' option. Your format will remain, and users will not be able to edit, but you will be able to add data. Regards, Sam Mathai Chacko (GL) On Oct 21, 10:45 am, Ayush Jain wrote: > Hello members, > > Thanks for your great participation i