Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macros and protect sheet
I need to do different things at once in my worksheet.
1. I need a macro to select a value from an autofilter (that part is done) 2. I need to protect the sheet (exept a few inputcells), the sheet containing various formulas (this is also done) 3. I need both at the same time.... The macro stops when it should select a spesific value in the autofilter. I have formatted the cells in the filter (and the inputcells) to be hidden, not locked, and the sheet is protected - and the user can choose unlocked cells and use the autofilter. Do I need to install some function into vb? I needed this when I wanted another macro to make pivottables, but I cannot remember why. I hope someone can help me with this, I have a really short deadline. Thanks! traima |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macros and protect sheet
Show us the two bits of done code.
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "traima" wrote in message ... I need to do different things at once in my worksheet. 1. I need a macro to select a value from an autofilter (that part is done) 2. I need to protect the sheet (exept a few inputcells), the sheet containing various formulas (this is also done) 3. I need both at the same time.... The macro stops when it should select a spesific value in the autofilter. I have formatted the cells in the filter (and the inputcells) to be hidden, not locked, and the sheet is protected - and the user can choose unlocked cells and use the autofilter. Do I need to install some function into vb? I needed this when I wanted another macro to make pivottables, but I cannot remember why. I hope someone can help me with this, I have a really short deadline. Thanks! traima |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macros and protect sheet
You will not be able to use the filters if the sheet is protected. In
your macro you will have to unprotect the sheet, allow filters to be used, then protect the sheet again. Hope this helps. Pete On Jan 25, 3:55 pm, traima wrote: I need to do different things at once in my worksheet. 1. I need a macro to select a value from an autofilter (that part is done) 2. I need to protect the sheet (exept a few inputcells), the sheet containing various formulas (this is also done) 3. I need both at the same time.... The macro stops when it should select a spesific value in the autofilter. I have formatted the cells in the filter (and the inputcells) to be hidden, not locked, and the sheet is protected - and the user can choose unlocked cells and use the autofilter. Do I need to install some function into vb? I needed this when I wanted another macro to make pivottables, but I cannot remember why. I hope someone can help me with this, I have a really short deadline. Thanks! traima |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macros and protect sheet
Thanks Pete, this solved my problem!
traima "Pete_UK" wrote: You will not be able to use the filters if the sheet is protected. In your macro you will have to unprotect the sheet, allow filters to be used, then protect the sheet again. Hope this helps. Pete On Jan 25, 3:55 pm, traima wrote: I need to do different things at once in my worksheet. 1. I need a macro to select a value from an autofilter (that part is done) 2. I need to protect the sheet (exept a few inputcells), the sheet containing various formulas (this is also done) 3. I need both at the same time.... The macro stops when it should select a spesific value in the autofilter. I have formatted the cells in the filter (and the inputcells) to be hidden, not locked, and the sheet is protected - and the user can choose unlocked cells and use the autofilter. Do I need to install some function into vb? I needed this when I wanted another macro to make pivottables, but I cannot remember why. I hope someone can help me with this, I have a really short deadline. Thanks! traima |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macros and protect sheet
Glad to be of help - thanks for feeding back.
Pete On Jan 25, 9:12 pm, traima wrote: Thanks Pete, this solved my problem! traima "Pete_UK" wrote: You will not be able to use the filters if the sheet is protected. In your macro you will have to unprotect the sheet, allow filters to be used, then protect the sheet again. Hope this helps. Pete On Jan 25, 3:55 pm, traima wrote: I need to do different things at once in my worksheet. 1. I need a macro to select a value from an autofilter (that part is done) 2. I need to protect the sheet (exept a few inputcells), the sheet containing various formulas (this is also done) 3. I need both at the same time.... The macro stops when it should select a spesific value in the autofilter. I have formatted the cells in the filter (and the inputcells) to be hidden, not locked, and the sheet is protected - and the user can choose unlocked cells and use the autofilter. Do I need to install some function into vb? I needed this when I wanted another macro to make pivottables, but I cannot remember why. I hope someone can help me with this, I have a really short deadline. Thanks! traima- Hide quoted text -- Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run macros on protected sheet | Excel Discussion (Misc queries) | |||
Password protect a sheet without Macros | Excel Discussion (Misc queries) | |||
protecting macros for a protected sheet | Excel Discussion (Misc queries) | |||
Protect macros? | Excel Discussion (Misc queries) | |||
help with protect sheet | Excel Discussion (Misc queries) |