ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Command Buttons (https://www.excelbanter.com/excel-programming/375958-command-buttons.html)

wildauk

Command Buttons
 
My Son has made a Command button and when he copyed it to another cell, he
was not able to edit the code, when he opened the drop down menu the edit
cdoe opption was not there, has he changed the settings some where? what he
wants to do is copy the button to another cell and change the script so it
will work in its new home.

Thanks in advance wildauk

Jim Thomlinson

Command Buttons
 
Is the Code Protected? If so then remove the password from the project. You
may also need to remove the password from the workbook and/or worksheet.
--
HTH...

Jim Thomlinson


"wildauk" wrote:

My Son has made a Command button and when he copyed it to another cell, he
was not able to edit the code, when he opened the drop down menu the edit
cdoe opption was not there, has he changed the settings some where? what he
wants to do is copy the button to another cell and change the script so it
will work in its new home.

Thanks in advance wildauk


zz

Command Buttons
 
Maybe it has cleared the design mode option en the control toolbar.


"Jim Thomlinson" wrote in message
...
Is the Code Protected? If so then remove the password from the project.
You
may also need to remove the password from the workbook and/or worksheet.
--
HTH...

Jim Thomlinson


"wildauk" wrote:

My Son has made a Command button and when he copyed it to another cell,
he
was not able to edit the code, when he opened the drop down menu the edit
cdoe opption was not there, has he changed the settings some where? what
he
wants to do is copy the button to another cell and change the script so
it
will work in its new home.

Thanks in advance wildauk





All times are GMT +1. The time now is 08:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com