[email protected]I have a holiday planner i want a copy of this to be updated automatically when the main planner is changed.
This is so others can view the planner but not change it.
The protect function isnt any good as there are other worksheets on the same file I dont want anybody to view, and ofther the potection is not re-applied after changing it. does anybody know how to do this.
This is so others can view the planner but not change it.
The protect function isnt any good as there are other worksheets on the same file I dont want anybody to view, and ofther the potection is not re-applied after changing it. does anybody know how to do this.