Re: $$Excel-Macros$$ Re: Restrict cell format not values
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 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 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 > -- 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 excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Restrict cell format not values
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 data. > > Regards, > > Sam Mathai Chacko (GL) > > On Oct 21, 10:45 am, Ayush Jain 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
$$Excel-Macros$$ Re: Restrict cell format not values
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 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. -- -- 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