karen2712
03-06-2007, 03:13 AM
Hi
I've got a user form working just how I want on an Excel sheet. I've set the form to load by clicking the command button but is it possible to have the form load automatically when the Workbook is opened?
Is it also possible to protect the data and the code so that it can't be changed by users, this form is going to be published on the intranet at work and could be used by many people at the same time. I'm not bothered whether the sheet itself is hidden or whether the sheet is protected but still visible - looking for advice on which is the best method to use really.
Could you help on this please.
Many thanks
Karen
I've got a user form working just how I want on an Excel sheet. I've set the form to load by clicking the command button but is it possible to have the form load automatically when the Workbook is opened?
Is it also possible to protect the data and the code so that it can't be changed by users, this form is going to be published on the intranet at work and could be used by many people at the same time. I'm not bothered whether the sheet itself is hidden or whether the sheet is protected but still visible - looking for advice on which is the best method to use really.
Could you help on this please.
Many thanks
Karen