format >Unlock all cells user is allowed to access>format your cell>PROTECT the sheet to allow values>
Don Guillett SalesAid Software dguille...@gmail.com From: Ayush Jain Sent: Friday, October 21, 2011 12:45 AM To: excel-macros Subject: $$Excel-Macros$$ Restrict cell format not values 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 -- ---------------------------------------------------------------------------------- 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
