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