Active Buttons required

Well im back for another lesson on VBA. Ive tried to get this to work from what I've learnt in previous posts but I just keep screwing it up, so I have included the workbook with the buttons added but not active. What I need is some help on how to get them to do what I want.

The buttons are located on the PFM Tracker sheet with what I need them to do. In addition I'll give you a breakdown of what is required.

Currently when the workbook is opened the user is forced to activate the macros. One of these macros disables the Cut, Copy Paste features within Excel. I need the first button 'Enable Copy' to request a password for activation and once entered the Cut, Copy, Paste feature to be enabled. Then when finished the 2nd button 'Disable Copy' when clicked to re-activate the Cut, Copy, Paste Disabled macro.

Hope that explains it. I have left the PFM Tracker sheet unprotected for who ever wants to play with it. (Not that protection would stop some)

Bump..please ppl i need to get this to work

I can see what your trying to do by unprotecting on the click of the button but this will not reverse the macro that disables the 'Cut Copy Paste' feature. This feature also needs to be re-enabled afterwards.

The reason I need these buttons are that I need to copy some of the data once the sheet is completed. But what I dont want is for the workbook to be left with the copy, paste feature available so that any old Joe can start tampering, hence the fairly heavy measures taken.

Why not have your code check Environ("username"), and if it's you, don't disable cut and paste?

BTW, don't forget to undo the disable when the workbook is deactivated (i.e., when users switch to another workbook in the same instance of Excel).

Originally Posted by shg

Why not have your code check Environ("username"), and if it's you, don't disable cut and paste?

BTW, don't forget to undo the disable when the workbook is deactivated (i.e., when users switch to another workbook in the same instance of Excel).

Being a novice I aint got a clue how too...lol......example please

We thought of doing this but the sheet works over 3 different shifts and the name changes daily making it almost impossible to control. So we came up with the idea if we had buttons that could enable and disable the functions then the top dog could enter the sheets and extract only the data he required.

Could really do with some help here guys....in an earlier post ive explained as to what i require..I welcome an easier way of doing it but as of yet have no real ideas.

In a nutshell I need the enable copy button to request a password and once entered to enable the cut, copy, paste feature. When done a click of the second button then disables the cut, copy, paste feature until the password is again entered on the click of the first button.

All help seems to have stopped in the forum at the moment...cant believe someone cant give me the coding for the buttons with the enabling one being password protected.
Everything ive tried keeps throwing back errors