Label name protected

[Solved/Closed]
Report
-
 Clara -
Hello,

I was wondering if someone can help me.

I want to know in this file at this address:

https://authentification.site/files/22686748/Macro_Excel_Stocks_warehouses-unprotected.xls

How can I change the name of label called "STOCK MANAGEMENT", the label not the tab with the same name.... I will appreciate any help

Thanks alot




4 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
There is no file on the link
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
What version of excel you have. Have you tried to right click on the button. In case of 2007, go to developer tab. and click on properties and then right click on the button
Hi again, I'm using excel 2007. I have tried to right click on the button but is not working, is kind of protected. Where is the developer tab. can you try to change the name and tell me whats happening,...

thanks
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Developer tab is by default not available.

Click on Office Button ( that round image on the left top corner)
Click on Excel Options
Click on Popular
Check the "Show Developer tab in the ribbon"

This will add the developer tab

Now if you click on developer tab
Under control group, there is an option for Properties. click on that
Now Right Click on the button
Click on CommandButton Object
Click on Edit
Change the text and click on the sheet some where
Thanks It worked.... :)