How to undo then redo the current formats in a macro

G

Guest

I have an excel spread sheet that acts as an invoice. I have created macros that allow me to "white out" information that I don't neccessarily want the customer to see and that works fine - I just change the font to white to match the default "no fill" cell background

If, in a macro, I wanted to temporarilty delete the current formats (both regular formats and conditional formats), print the sheet, and then reinstate the prior formats that were deleted - is that possible

When I experiment with the macro recorder using the "undo" button, it ends up showing that I didn't do anything in the actual Visual Basic Code

Can I undo and redo the current formats in a macro? Your help is appreciated.
 
F

Frank Kabel

Hi David
you can't undo your macro actions. you may store the old formats in
some variables and re-set the formats manually in your code after the
printout
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I reactivate my undo and redo functions in Excel? 1
How do I pause a macro? 4
copy 2007 created macro to run in 2003 4
What's the best way to count conditional formats? 3
Can I retain the formats in a pivot when expanded to additional wo 1
How to do the "REDO" action in Excel programatically. 2
Inactive UNDO REDo button due to a macro 2
How to clear the Redo queue? 1

Top