Here's a link too http://excelhints.com/2008/10/21/protect-cell-formats/
Regards, Sam On Oct 21, 3:06 pm, GoldenLance <samde...@gmail.com> 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 data. > > Regards, > > Sam Mathai Chacko (GL) > > On Oct 21, 10:45 am, Ayush Jain <jainayus...@gmail.com> wrote: > > > > > Hello members, > > > Thanks for your great participation in the group. > > > I have a query too. I want to restrict the cell format , so that user should > > not be able to change the format but enter the values. > > If the currency format is dollar or percent, the should be able to enter > > values only and should not be allow to change the format. > > > It would be great if we could do it without VBA ,but advise all ideas that > > you can think of. > > > Many thanks in advance > > > Best regards, > > Ayush Jain > > Group Manager.- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel