I need a macro that will make a protected worksheet's name not to be able to be changed. Thanks.
I need a macro that will make a protected worksheet's name not to be able to be changed. Thanks.
Have a look at this link: http://stackoverflow.com/questions/8...e-entire-sheet
I actually found that and tried it but it did not work.
I tried it on a dummy sheet and it worked for me. Did you put the code into the worksheet code module?
yes but i will try again. maybe i did something wrong. This worksheet is protected. Do you think that makes a difference?
Hi, backyardfun,
if your VBA Code needs that you should consider to use the worksheets CodeName to work with opposed to the visible name on the worksheet.
would select the sheet listed by tab as InCome. Assuming the CodeName is Sheet2 for InCome you could usePlease Login or Register to view this content.
as well. You would not need to bother for the displayed name when referring to it.Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Try:
Please Login or Register to view this content.
That is what I am currently trying to do but there are some instances where I can't get it to work and this is my alternative.
Perhaps like this?
Right click on the sheet tab where you wish to protect tab name then click on "View Code" in the windows that opends paste this code after changing sheet name to your needs.
Then go to "Developer" tab -> Visual Basic -> Tools ->VBAProjcetProperties and set a password.Please Login or Register to view this content.
People can still change tab name but as soon as they click on this sheet i.e. sheet gets activated the tab name changes back to the name you specified in macro.
Alf
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks