Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Macro for Filter Switches ... Maybe???
Excel 2000 ... I have a somewhat similar post on board
from yesterday. It's all about keeping Filter Switches active on a Protected TabSheet & being able to Filter & UnFilter List without running into what I call Calculation churn ... Also, I do not write Macros ... I only record them. What I have: File is 30 Cols x 5000 records ... Sheet is Protected (no password) ... Filter Switches for all Columns reside on Row 2 ... Various Filter Switches may be activated ... Only 2 Cols have simple Formulas Many Cols have Conditional Formatting Formulas My Calculation is set to "Automatic", but this is causing a certian amount of calculation churn as each Filter is set back to view "ALL". Above said ... I am looking for a Macro (or idea) ... Basically, I want Macro to: Unprotect Sheet Set Calculation to "Manual" Set any activated Filter Switches back to view ALL Set Calculation to "Automatic" Protect Sheet Not sure if this is enough info, but have a great respect & appreciation for the "Magic" that comes from this board. Thanks ... Kha |
#2
|
|||
|
|||
You have a possible solution at your original post.
Ken wrote: Excel 2000 ... I have a somewhat similar post on board from yesterday. It's all about keeping Filter Switches active on a Protected TabSheet & being able to Filter & UnFilter List without running into what I call Calculation churn ... Also, I do not write Macros ... I only record them. What I have: File is 30 Cols x 5000 records ... Sheet is Protected (no password) ... Filter Switches for all Columns reside on Row 2 ... Various Filter Switches may be activated ... Only 2 Cols have simple Formulas Many Cols have Conditional Formatting Formulas My Calculation is set to "Automatic", but this is causing a certian amount of calculation churn as each Filter is set back to view "ALL". Above said ... I am looking for a Macro (or idea) ... Basically, I want Macro to: Unprotect Sheet Set Calculation to "Manual" Set any activated Filter Switches back to view ALL Set Calculation to "Automatic" Protect Sheet Not sure if this is enough info, but have a great respect & appreciation for the "Magic" that comes from this board. Thanks ... Kha -- Dave Peterson |
#3
|
|||
|
|||
You say that you record macros, this sounds like an ideal candidate for a
recorded macro. -- HTH RP (remove nothere from the email address if mailing direct) "Ken" wrote in message ... Excel 2000 ... I have a somewhat similar post on board from yesterday. It's all about keeping Filter Switches active on a Protected TabSheet & being able to Filter & UnFilter List without running into what I call Calculation churn ... Also, I do not write Macros ... I only record them. What I have: File is 30 Cols x 5000 records ... Sheet is Protected (no password) ... Filter Switches for all Columns reside on Row 2 ... Various Filter Switches may be activated ... Only 2 Cols have simple Formulas Many Cols have Conditional Formatting Formulas My Calculation is set to "Automatic", but this is causing a certian amount of calculation churn as each Filter is set back to view "ALL". Above said ... I am looking for a Macro (or idea) ... Basically, I want Macro to: Unprotect Sheet Set Calculation to "Manual" Set any activated Filter Switches back to view ALL Set Calculation to "Automatic" Protect Sheet Not sure if this is enough info, but have a great respect & appreciation for the "Magic" that comes from this board. Thanks ... Kha |
#4
|
|||
|
|||
Dave ... Sorry for the multiple post, but I was not sure I
was clarifying well enough with first post & thought issue today enough different to warrant a new post. Above said ... I responded to original post with another question regarding ... "Option Explicit" ... Thanks ... Kha -----Original Message----- You have a possible solution at your original post. Ken wrote: Excel 2000 ... I have a somewhat similar post on board from yesterday. It's all about keeping Filter Switches active on a Protected TabSheet & being able to Filter & UnFilter List without running into what I call Calculation churn ... Also, I do not write Macros ... I only record them. What I have: File is 30 Cols x 5000 records ... Sheet is Protected (no password) ... Filter Switches for all Columns reside on Row 2 ... Various Filter Switches may be activated ... Only 2 Cols have simple Formulas Many Cols have Conditional Formatting Formulas My Calculation is set to "Automatic", but this is causing a certian amount of calculation churn as each Filter is set back to view "ALL". Above said ... I am looking for a Macro (or idea) ... Basically, I want Macro to: Unprotect Sheet Set Calculation to "Manual" Set any activated Filter Switches back to view ALL Set Calculation to "Automatic" Protect Sheet Not sure if this is enough info, but have a great respect & appreciation for the "Magic" that comes from this board. Thanks ... Kha -- Dave Peterson . |
#5
|
|||
|
|||
And you have another reply at that other thread <bg.
Ken wrote: Dave ... Sorry for the multiple post, but I was not sure I was clarifying well enough with first post & thought issue today enough different to warrant a new post. Above said ... I responded to original post with another question regarding ... "Option Explicit" ... Thanks ... Kha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Date macro | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) | |||
Macro Formula revision? | Excel Worksheet Functions |