Hello. I'm going to be making some spreadsheets for other people to use at my work, problem is these other people know very little about excel. Plus I've only ever made spreadsheets for myself before.
What I'm looking for is a bit of help, to be pointed in the right direction for certain things
For example.
I've looked up the way you can lock cells and protect sheets, that's certainly going to be a big help so no-one will delete my formulas
I'm also hoping to create sheets solely where they will input the data, and then that data can be added to a seperate sheet which contains all previous data (does this method have a name?)
I've done this before using macros, but some of the spreadsheets I'll be making will be on a network used by many different computers so I'm hoping to keep macros down to a minimum
Also what macros can you get away with without the default excel security settings warning users. Where's the best place I can look into macro security
And if anyone's got any advice or something I should look into for making spreadsheets to be used by other people will be greatly appreciated.
Bookmarks