golf4
Active Member
- Joined
- Jul 8, 2002
- Messages
- 452
Hi everyone -
It's been a while since the last time I posted and hope everybody had a happy and safe New Year.
A quick issue came up at work that I'm looking for a little imput on: I created a sizable spreadsheet that tracks our vacant housing units from the time the tenant moves out all the way through getting the made-ready unit back from our Maintenance Department.
The spreadsheet has quite a few columns, i.e. Vacate Date, Back from Maintenance Date, Re-Rented Date, etc. In an effort to make the spreadsheet more usable, I have also turned on the Auto-Filter for all of the columns. What we have been running into is that employees will filter a column and then save the spreadsheet with the filtered column still on. Then, when someone else pulls up the the spreadsheet, and they are not familiar with Auto-Filter, they don't know they are not seeing all of the data.
I was hoping someone could help me with code that would turn off the filtering but not necessarily the Auto-Filter anytime the spreadsheet is saved and closed. This should, hopefully, correct the problem.
Thanks,
Golf
It's been a while since the last time I posted and hope everybody had a happy and safe New Year.
A quick issue came up at work that I'm looking for a little imput on: I created a sizable spreadsheet that tracks our vacant housing units from the time the tenant moves out all the way through getting the made-ready unit back from our Maintenance Department.
The spreadsheet has quite a few columns, i.e. Vacate Date, Back from Maintenance Date, Re-Rented Date, etc. In an effort to make the spreadsheet more usable, I have also turned on the Auto-Filter for all of the columns. What we have been running into is that employees will filter a column and then save the spreadsheet with the filtered column still on. Then, when someone else pulls up the the spreadsheet, and they are not familiar with Auto-Filter, they don't know they are not seeing all of the data.
I was hoping someone could help me with code that would turn off the filtering but not necessarily the Auto-Filter anytime the spreadsheet is saved and closed. This should, hopefully, correct the problem.
Thanks,
Golf