| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
invalid use of property message
I am trying to cre4ate a macro that checks the value of a number of sheets to
determine if they are already visible and if so it will not close them - With Sheets("Pay Inflation - Biometrics") Sheets ("Statistics") Sheets ("Direct Cost Savings Breakdown") Sheets ("OT Reduction") Sheets ("Nurse OT Reduction") Sheets ("Premium Labor Utilization") Sheets ("Pay inflation - Timestamp") Sheets ("Calculation Error") Sheets ("Leave Inflation") Sheets ("Absenteeism") Sheets ("Walk Time Reductions") Sheets ("Paper Costs") Sheets ("Direct Cost Savings") Sheets ("Financial Analysis") Sheets ("Project Timeline Savings ") Sheets ("Total Cost of Ownership") If .Visible < xlSheetVisible Then .Visible = Not .Visible End If End With When I run the macro I get the "invalid use of property" message.. Can some one tell me what I am doing wrong ?? -- Thanks Larry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Invalid use of Property" message | Excel Programming | |||
| Runtime error 380 - Could not set the list property. Invalid property value. | Excel Programming | |||
| Clear Form results in INCORRECT "Invalid Property" message.... | Excel Programming | |||
| Runtime Error 380 – Could not set the list property. Invalid property value | Excel Programming | |||
| Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming | |||
Threaded Mode
