Replies

I use Outlook 2010. I do not want to automatically move the e-mail to the folder. I need to read the e-mail, detach a file, and then move it. I currently have a macro that does that within my own mail box. I just cant quite figure out how to get the macro to move it to the shared mailbox.

This is for the U.S.A. only.

I need to distribute the Excel file to many people and I cannot ask them to install ClickYes.

Is there another solution that is VBA based? Or can I change the security settings?

Thanks,

(No Text)

(No Text)

I just wanted to thank all of you for your suggestions. They were all very good and would have done the job. However, I do not give up easily, so I wrote an add-in that can toggle the Auto Hyperlinks in Excel.

I am posting the add-in for all to enjoy. The code is un-protected, but it is not commented very well. Please feel free to critique the code, but please be nice about it.

When you load the Add-in a toolbar will be added with one button. If you do not wish to keep the toolbar, you can Press the ALT key and drag the button to a new toolbar and then delete the toolbar that the add-in created.

If for some reason you loose the toolbar and button, just unload and then reload the add-in.

I hope others find this useful.

Regards,

I do not have the “AutoFormat As You Type” tab on the AutoCorrect dialog box in Excel. I do have that tab in Word and I did uncheck the box, but Excel is still formatting web address as hyperlinks.

Regards,

I do not have the “AutoFormat As You Type” tab on the AutoCorrect dialog box in Excel. I do have that tab in Word and I did uncheck the box, but Excel is still formatting web address as hyperlinks.

Regards,

No, I clear all contents and formatting from the cells.

No, I clear all contents and formatting from the cells.

Thanks,

It took care of most of the sheets in the workbook. But there are still a few stuborn ones that will not reset the last cell. I am happy with the results, but do you know why these three sheets cannot have the last cell reset?

Regards,

Thanks,

It took care of most of the sheets in the workbook. But there are still a few stuborn ones that will not reset the last cell. I am happy with the results, but do you know why these three sheets cannot have the last cell reset?

Regards,

Sorry about that.

Sorry about that.

Thanks for your suggestion, but I cannot seem to get it to work. I am attaching a sample of the DB. If you have time, would you mind taking a look at it and telling me what I am doing wrong.

Regards,