ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Using Named Range with protection on the worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/108826-using-named-range-protection-worksheet.html)

txjag007

Using Named Range with protection on the worksheet
 
I have set up 4 blockes of named ranges for a form I am creating. I need to
lock several cells so the end user can't alter the formulas. When I protect
hte worksheet the named range tabbing no longer works. Anyone have a work
around or another idea?

Jim Rech

Using Named Range with protection on the worksheet
 
named range tabbing no longer works

I don't think we know what you mean.

--
Jim
"txjag007" wrote in message
...
|I have set up 4 blockes of named ranges for a form I am creating. I need to
| lock several cells so the end user can't alter the formulas. When I
protect
| hte worksheet the named range tabbing no longer works. Anyone have a work
| around or another idea?




All times are GMT +1. The time now is 05:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com