| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Allow users of protected sheet to use macro involving custom filte
Hi:
I have created a macro that works for me when unprotected. However, when I re-protect it before sending to mass users, it will not allow the custom filter part of the macro to occur and returns an error. I have tried checking the box in 'Protection'- 'Protect Sheet' that allows auto filter but there does not seem to be an option for custom filter. Is there a way around this without un-protecting the sheet? thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow custom update button to work while sheet is protected | Excel Discussion (Misc queries) | |||
| How do i allow users to insert hyperlinks into a protected sheet | Excel Discussion (Misc queries) | |||
| On protected Excel sheet users be able to group/ungroup rows/colum | Excel Worksheet Functions | |||
| Hiding columns, custom views, protected sheet | Excel Discussion (Misc queries) | |||
| use macro button to run macro in protected sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
