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

2011-10-21 Thread Sam Mathai Chacko
*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 th

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

2011-10-21 Thread dguillett1
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 v

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

2011-10-20 Thread Ayush Jain
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