1
vote
1answer
38 views

VBA change Script on multiple tables

Via this forum I found a way to refresh autofilters in a table automatically after the data in a excel worksheet has changed, using this VBA script: Private Sub Worksheet_Change(ByVal Target As ...
0
votes
1answer
423 views

Printing a Word Document in Colour using VBA code to print

I have a word document that we do not want the users to edit once it had been generated from the database. We have set up a VBA module to print the document automatically after opening, but we need ...
3
votes
2answers
766 views

Edit date field code on multiple Word Documents

I have multiple word documents that have a date field code displaying the current date. I need a way to modify each document so that it shows the CreateDate field instead of Date. The format for each ...
1
vote
2answers
425 views

Using Activecell in a VBA formula

I am a newbie @ VBA. I want to use the value of a formula in the active cell to feed into another formula (a sum where the active cell sets the limit of the colum rows to be included in the sum). ...
0
votes
1answer
958 views

How to password protect multiple Excel 2007 files with multiple passwords using a Macro?

I'm new here so please let me know if my post is incorrect or anything like that. I currently have a macro that splits out one excel file into multiple files and saves them separately. This step I ...