View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TKM TKM is offline
external usenet poster
 
Posts: 33
Default Automate Menu item with VBA?

I have several reports that I export from Access to Excel which look
terrible. I was wondering if there is a simple way to auto format the columns
(align) by code via the menu item? Example the manual way. Select complete
workbook, format, columns, autoformat. can this be done via VBA?