| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sheet protected - user cannot interact
I have devised a macro that protects a worksheet so that data can only be
modified via the macro user form. This works fine however the users cannot interact with the data as I would like, for example expand and collapse groups, as it would seem that protecting the worksheet disables this ability. Is there any way to protect the data but not exclude the user from doing such basic things? Any help greatly appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Tabbing thru User-Edit Cells in Protected Sheet | Excel Discussion (Misc queries) | |||
| Protected sheet question -- way to allow user to change text alignment and font style? | Excel Programming | |||
| Relacing default Excel message box when user attempts to change locked cell on protected sheet. | Excel Programming | |||
| Interact with Spreadsheet Model via the web. | Excel Programming | |||
| Having a macro interact with a dialog box. | Excel Programming | |||
Threaded Mode
