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

ps.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

g4rod wrote:

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


--

Dave Peterson