Saving Excel Spreadsheet

[medieval]

Hi,

Ok, I'll keep it simple and you can ask me if you need more details...

I have created a macro to tidy up, colour, currency change, date format a spreadsheet. This is then saved to the desktop.
I have it so I am not prompted for errors.

The spreadsheet saves, no problem. Albeit it doesn't save all the nice, pwetty stuff I've done to it.

Any ideas?

thanks,
medieval.

 

[AnotherHiggins]

enable errors to see what it's trying to tell you.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[bdmangum]

By having it so you are not prompted for errors, how can you know if all the work you are doing actually completes? Perhaps an error occurs and none of the work is performed...