I know this is a simple one .. but I cant find the answer in here using search .. so I've got to ask this question ..
I want to run a macro that gets the current worksheet name from the tab at the bottom and then changes it to a set string eg; "balance"
I know its simple .. but I dont know how to read the current worksheet name and change it .. cos the user may have manually changed the tab name.
Secondly .. is there a way of stopping the users from changing sheet tab names ?
Thanks
Bill
I want to run a macro that gets the current worksheet name from the tab at the bottom and then changes it to a set string eg; "balance"
I know its simple .. but I dont know how to read the current worksheet name and change it .. cos the user may have manually changed the tab name.
Secondly .. is there a way of stopping the users from changing sheet tab names ?
Thanks
Bill