Hi - I am in need of some help and am hoping that someone here can provide it!

I use a lot of macros for our shared office spread sheets, but they are fairly basic derived from recordings rather than writing VBA. But now I need a more advanced function that I can't do without some simple programming...

I need to find a way of limiting a button-activated macro that copies material to a protected area so certain users can't use it. The ideal would be a popup dialogue in the macro that asks for a password, proceeds when it is given, or quits for an error or cancel.

Thanks to all that look. Kind regards

David