Bob,

Thanks for your help. And I like the idea of a toggle for Microsoft, but I
like better for me right now the ability to paste in the code as I need for
multiple workbooks.

I was thinking I could paste in both the activate and de-activate codes
together on each sheet I wanted to use the feature on. Otherwise, I can only
have this toggle button for the sheet you do it to.

Does that make sense? This way, it seems very straightforward and I can
share the feature with others. And we can use it only on the worksheets we
want to, and by simply de-activating get the sheets back to their untouched,
native form.

It must be pretty simple (for you, not for me) to un-do your macro with one
that puts everything back to the default setting. Is there a way to get back
to the default settings with a "de-activate" code for now?

You're too good to me,

Jay

--------------------------------------------------------------------------------------------------------


"Bob Phillips" wrote:


"Indiana Jay" wrote in message
...
Bob,

I'm not sure I can send this workbook with financial data from the company
I'm doing contract accounting work for in Boston, but isn't there a way to
De-Activate the code by reversing the steps the code does when it is
activated?


That is the principle of how you would do it. But your idea of a toggle is
eminently sensible, and I think the way to go. Could you not strip the
confidential data out, even if it mean the data worksheets. I don't need to
see the data, just have your workbook to add the toggle.


This is really what I need. And I now understand that the printing codce
belongs with the workbook, not the worksheet. I did not read it carefully
enough.


That''s good news.


By the way, what do you do for work? You seem to know this stuff pretty
well.


I'm in IT, I'm a design consultant. I do a bit of Excel, Office, VBA, VB
work, but it is not my primary occupation.