| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Options when Protecting Worksheet
When I Protect a worksheet, there are options I can select
or de-select that the user's can access. When I protect with a macro, how can I keep the user's from selecting locked cells? TIA, Brad E. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Options when Protecting Worksheet
You can set the same options with VBA.
-- Regards, Tom Ogilvy "Brad E" wrote in message ... When I Protect a worksheet, there are options I can select or de-select that the user's can access. When I protect with a macro, how can I keep the user's from selecting locked cells? TIA, Brad E. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Options when Protecting Worksheet
Hi
you can do the same within VBA. Just record a macro while settings these options manually to see what options you have in VBA -- Regards Frank Kabel Frankfurt, Germany Brad E wrote: When I Protect a worksheet, there are options I can select or de-select that the user's can access. When I protect with a macro, how can I keep the user's from selecting locked cells? TIA, Brad E. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protecting worksheet | Excel Worksheet Functions | |||
| Protecting excel general options | Excel Discussion (Misc queries) | |||
| Un-Protecting a Worksheet | Excel Discussion (Misc queries) | |||
| protecting the worksheet | Excel Worksheet Functions | |||
| Protecting Worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
