View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Victor Delta[_2_] Victor Delta[_2_] is offline
external usenet poster
 
Posts: 199
Default Help with Excel macro

I have an Excel macro which is designed to minimise and then save the
open/active spreadsheet:


Application.WindowState = xlMinimized

ActiveWorkbook.Save


However, when it operates on one particular spreadsheet - "my work.xls" -
between the minimising and saving I would like it to run another macro
called "alter format". Assuming this is possible, can someone help me with
the code to achieve this please?


Many thanks