Posted by M Walker on July 03, 2001 2:38 AM
I'm a complete beginer at writing macros and need some help.
Ideally i wouild like a macro that runs when the workbook is accessed. This would involve the user being confronted with a userform rather than the workbook its self. The user would then use the forms rather than have access to the spreadsheets (i would like to reduce access to the information on the sheets and introduce a password to edit them - eventually)
I've desgined the sheets and know what i'd like them to do, but i am at a loss as to how i can automatically run the userforms when the workbook is accessed.
Any help would be very much appreciated
Thanks in advance,