ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Cell Protection Within a Worksheet (https://www.excelbanter.com/excel-programming/326468-cell-protection-within-worksheet.html)

Jeffrey Kearns via OfficeKB.com

Cell Protection Within a Worksheet
 
I would like to know if you can protect a cell within a worksheet so that
when selected a form pops up that is password protected so the data entered
is by someone on a dropdown list. It is a range of cells in a section of a
worksheet that would be controlled this way. If this is possible, please
reply.
Thanks,
Jeff Kearns

--
Message posted via http://www.officekb.com

Tom Ogilvy

Cell Protection Within a Worksheet
 
What version of Office? If xl2002 or later you can assign protection based
on user.

--
Regards,
Tom Ogilvy

"Jeffrey Kearns via OfficeKB.com" wrote in message
...
I would like to know if you can protect a cell within a worksheet so that
when selected a form pops up that is password protected so the data

entered
is by someone on a dropdown list. It is a range of cells in a section of a
worksheet that would be controlled this way. If this is possible, please
reply.
Thanks,
Jeff Kearns

--
Message posted via http://www.officekb.com




Jeffrey Kearns via OfficeKB.com

Cell Protection Within a Worksheet
 
XL 2000 PRO v.9.0

--
Message posted via http://www.officekb.com


All times are GMT +1. The time now is 05:58 PM.

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