View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marco Marco is offline
external usenet poster
 
Posts: 69
Default Attach macro to a cell

Can you attach a macro to a cell which when clicked activates the macro or
can you attach a macro to a button/shape inbedded in a form as before
activates when clicked.
The reason for asking is I have a macro to auto save a file using a selected
cell range and current date as file name to a chosen location within a shared
drive.
The idea being to make it more user friendly for those not to keen on IT.
Can any one help please!!
--
Marco