Running macros automatically-AutoFit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've used Jim Rech's autofit macro for merged cells. It works great. Thanks!

Seems I have to use alt-f8 to run the macro and make the merged cells
autofit everytime I make a change (add text). Is there a way to make it work
automatically, perhaps so that the macro is "always running"?
 
What you want is to run the macro on a worksheet change event. To do that,
make sure the macro code is in the worksheet (Right-click the sheet and hit
View Code and paste it into the code window there, if it's not already).
Then, rename the macro so that it's called Private Sub
Worksheet_Change(ByVal Target As Range)
(or you can create a NEW macro with this name and call the other macro from
it.
I am not sure this will work perfectly for you, but will definitely give you
a place to start.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
 

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

Run macros automatically-AutoFit 3
Referencing a cell in other worksheet that is using autofit row he 3
Linked cells and text wrap / autofit function 1
Currency autofit 5
AutoFit not working properly 2
Windows 7 Autofit row heights of merged cells in protected worksheet 0
Problems Creating an Autofit Macro for Merged Cells 0
Excel autofit row height not working 0

Back
Top