View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
g4rod g4rod is offline
external usenet poster
 
Posts: 3
Default Autoname a save as file from a cell in a read only file

I have a read only file set up to type in monthly staff hours, when you go to
save the file it points you to a save as box as it is a read only file. I
have used concatenate to use information from the table to produce a
standardised file name. Is there any way to set the properties so when the
save as box appears it will name the file from a cell in the table?

Cheers

Garod