Wanted: macro to toggle a macro on & off

[Monsignor]

I'm using code that disables Cut-Copy-Paste.

It works beautifully. Problem: I can't do any development with it enabled.

How can I toggle it off and on? I'm thinking about a button that's attached to a macro. Or it there a simpler way?

Thanks all!!!

 

[njimack]

All you need to do is run the following code either attached to a command button, or via the Immediate window:

call ToggleCutCopyAndPaste(True)

 

[Monsignor]

All you need to do is run the following code either attached to a command button, or via the Immediate window:

call ToggleCutCopyAndPaste(True)

AWESOME! This turned the macro off.
How do I turn the macro back on after I've made my edits and turn the spreadsheet back over to the user?

 

[njimack]

AWESOME! This turned the macro off.
How do I turn the macro back on after I've made my edits and turn the spreadsheet back over to the user?

call ToggleCutCopyAndPaste(False)</pre>

 

[Monsignor]

Ok!!!! Figured it out. A second button assigned to:

call ToggleCutCopyAndPaste(False)

Thanks so much!!!!

 

[Monsignor]

call ToggleCutCopyAndPaste(False)</pre>

I intuited that right after I posted the request. Work like a charm.

 

[Monsignor]

This macro has started disrupting my other spreadsheets.

Whenever this spreadsheet that has this macro in it is closed, none of my other spreadsheets have CUT-COPY-PASTE capability.

I go in and see: Call ToggleCutCopyAndPaste(False)
I manually change it to (True) and then hit the Run icon. My capabilities are all returned.

When I close the spreadsheet, I'm asked if I want to save. I say Yes and Excel crashes.

Any ideas what's going on? How can I properly uninstall this code?