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 <[email protected]> wrote: > Here's a link too > > http://excelhints.com/2008/10/21/protect-cell-formats/ > > Regards, > > Sam > > On Oct 21, 3:06 pm, GoldenLance <[email protected]> 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 <[email protected]> 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 [email protected] > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Best regards, Ayush Jain -- ---------------------------------------------------------------------------------- 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 [email protected] <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
