i have a need to change the tab name on the bottom of an excel sheet by
macro. any ideas

Hi

Sub NameSheet(myoldName as String, myNewName as String)
Activeworkbook.Worksheets(myOldString).Name = myNewString
end sub

In the calling sub you would use, for example

NameSheet "Sheet1", "DataSheet"

to change Sheet1 to DataSheet.
Be careful with illegal characters in the sheet name like /, \, ?, :,
[, ] and * or they will generate an error.

regards
Paul

cinders wrote:

> i have a need to change the tab name on the bottom of an excel sheet by
> macro. any ideas

This will change the name of the first sheet to the name "hello"

Sub Changename()
Sheets(1).Name = "hello"
End Sub

Best regards
Petter

cinders skrev:

> i have a need to change the tab name on the bottom of an excel sheet by
> macro. any ideas
>
>

Sounds good to me, perhaps you can help with something else. I am now
trying to remove all the toolbars and side bars on the worksheet. I
know about the full screen option on the"view" pull down but can the
screen be made any less cluttered than that ??

Peter

(i wish i had a cool but naughty nick name like fingerjob, mines
cinders cos I have to be home by 12.oo otherwise my missus locks the
door)




Fingerjob wrote:

> This will change the name of the first sheet to the name "hello"
>
> Sub Changename()
> Sheets(1).Name = "hello"
> End Sub
>
> Best regards
> Petter
>
> cinders skrev:
>
> > i have a need to change the tab name on the bottom of an excel sheet by
> > macro. any ideas
> >
> >

Hi
Experience has shown that most users hate having their menu bars taken
away, so you might want to rethink this. It is a bit of a pain too, as
you have to put them back, and you have to take account of the machine
crashing for example (what puts them back in that case?).
If you are determined, Googling this group with "removing menu bars"
would probably do it
regards
Paul

cinders wrote:

> Sounds good to me, perhaps you can help with something else. I am now
> trying to remove all the toolbars and side bars on the worksheet. I
> know about the full screen option on the"view" pull down but can the
> screen be made any less cluttered than that ??
>
> Peter
>
> (i wish i had a cool but naughty nick name like fingerjob, mines
> cinders cos I have to be home by 12.oo otherwise my missus locks the
> door)
>
>
>
>
> Fingerjob wrote:
>
> > This will change the name of the first sheet to the name "hello"
> >
> > Sub Changename()
> > Sheets(1).Name = "hello"
> > End Sub
> >
> > Best regards
> > Petter
> >
> > cinders skrev:
> >
> > > i have a need to change the tab name on the bottom of an excel sheet by
> > > macro. any ideas
> > >
> > >