Label name protected

Solved/Closed
Clara - May 29, 2010 at 01:12 PM
 Clara - May 29, 2010 at 06:22 PM
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 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 29, 2010 at 04:02 PM
There is no file on the link
0
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 29, 2010 at 05:37 PM
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
0
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
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 29, 2010 at 05:53 PM
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
0
Thanks It worked.... :)
0