changing tab name on the bottom of an Excel sheet by macro
 

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

changing tab name on the bottom of an Excel sheet by macro
 

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