Re: $$Excel-Macros$$ Excel 2007 Protect and unprotect

2013-04-09 Thread अनिल नारायण गवली
Dear Norman, Then share that sheet with us, Warm Regards, Gawli Anil On Tue, Apr 9, 2013 at 5:50 PM, Norman West wrote: > Hi Gawli, > > I protected the worksheets prior to looking at unprotecting certain user > cells > > Norman West > > > On Tuesday, April 9, 2013 11:12:18 AM UTC+1, अनिल नारा

Re: $$Excel-Macros$$ Excel 2007 Protect and unprotect

2013-04-09 Thread Norman West
Hi Gawli, I protected the worksheets prior to looking at unprotecting certain user cells Norman West On Tuesday, April 9, 2013 11:12:18 AM UTC+1, अनिल नारायण गवली wrote: > > Dear Norman, > > > Before Protecting the entire sheet first goto review and click on allow > users to edit the range

Re: $$Excel-Macros$$ Excel 2007 Protect and unprotect

2013-04-09 Thread अनिल नारायण गवली
Dear Norman, Before Protecting the entire sheet first goto review and click on allow users to edit the ranges and then protext the sheet. Warm Regards, Gawli Anil On Tue, Apr 9, 2013 at 3:32 PM, Norman West wrote: > I am reading "Excel 2007 for Dummies" in an endeavor to understand protect >

$$Excel-Macros$$ Excel 2007 Protect and unprotect

2013-04-09 Thread Norman West
I am reading "Excel 2007 for Dummies" in an endeavor to understand protect and unprotect worksheets, and am more confused than ever over what one would have thought an easy operation. I have written a 4 page worksheet program and wish to protect all sheets with the exception of some data entry