Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I have been given a spreadsheet with buttons overlaying one another. The top button is meant to function (open another sheet) however when (right) click on that button or any of the other buttons behind them in order to delete it, it doesn't border the button and change the curser to a four headed arrow to allow me to edit/delete. Can anyone tell me if there could be some kind of setting put on this button to dis-allow any editing? I did not create the spreadsheet so it is a bit mysterious to me. Thanks, Angeline |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Angeline
Is the file password protected? That would prevent you from editing the button. Try ToolsProtectionUnprotect -- Regards Roger Govier "Angeline" wrote in message ... Hello, I have been given a spreadsheet with buttons overlaying one another. The top button is meant to function (open another sheet) however when (right) click on that button or any of the other buttons behind them in order to delete it, it doesn't border the button and change the curser to a four headed arrow to allow me to edit/delete. Can anyone tell me if there could be some kind of setting put on this button to dis-allow any editing? I did not create the spreadsheet so it is a bit mysterious to me. Thanks, Angeline |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You may need to press the design mode button before you can edit/delete the
button(s). The design mode button is on the 'Control Toolbox' toolbar and the icon has a rule, a set square and a pencil on it. Press that button to allow you to edit the button, press it again once you have finished making changes. "Angeline" wrote: Hello, I have been given a spreadsheet with buttons overlaying one another. The top button is meant to function (open another sheet) however when (right) click on that button or any of the other buttons behind them in order to delete it, it doesn't border the button and change the curser to a four headed arrow to allow me to edit/delete. Can anyone tell me if there could be some kind of setting put on this button to dis-allow any editing? I did not create the spreadsheet so it is a bit mysterious to me. Thanks, Angeline |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Hot Dogs, Thanks, this did the trick ! Cheers, Angeline "hot dogs" wrote: You may need to press the design mode button before you can edit/delete the button(s). The design mode button is on the 'Control Toolbox' toolbar and the icon has a rule, a set square and a pencil on it. Press that button to allow you to edit the button, press it again once you have finished making changes. "Angeline" wrote: Hello, I have been given a spreadsheet with buttons overlaying one another. The top button is meant to function (open another sheet) however when (right) click on that button or any of the other buttons behind them in order to delete it, it doesn't border the button and change the curser to a four headed arrow to allow me to edit/delete. Can anyone tell me if there could be some kind of setting put on this button to dis-allow any editing? I did not create the spreadsheet so it is a bit mysterious to me. Thanks, Angeline |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using seperate sets of radio buttons in one sheet | Excel Worksheet Functions | |||
I can't delete a cell without deleting a row | Excel Discussion (Misc queries) | |||
deletion of option buttons | Excel Worksheet Functions | |||
Delete Buttons | Excel Discussion (Misc queries) | |||
Delete rows based on multiple criterias | Excel Discussion (Misc queries) |