On Fri, 2005-02-25 at 15:21, Paul wrote: > I'm sure you can do so with a macro, but don't think this would be > possible without.
[snip] > On Wed, 23 Feb 2005 22:01:47 -0700, Mike Thomas <[EMAIL PROTECTED]> wrote: > > Can I automatically name a sheet when I enter a name in a cell - say I enter > > "LOCATION" in cell 1A, can I link the sheet name to that cell and rename the > > sheet "LOCATION"? > > > > Mike I haven't done it but Paul is right it is possible with a macro. I think the following steps would be necessary: 1. You would need to assign a macro to the open document event. 2. That macro would assign a data change listener to the cell A1. 3. On changing the value in cell A1 the macro assigned in step 2 would change the sheets name. Thanks, Ian Laurenson --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
