#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default Can't delete buttons

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,886
Default Can't delete buttons

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 54
Default Can't delete buttons

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 20
Default Can't delete buttons


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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using seperate sets of radio buttons in one sheet Duster Excel Worksheet Functions 1 August 15th 06 04:41 PM
I can't delete a cell without deleting a row Tenny Excel Discussion (Misc queries) 2 June 30th 06 01:52 AM
deletion of option buttons gvm Excel Worksheet Functions 2 March 6th 06 01:56 AM
Delete Buttons Bill Martin Excel Discussion (Misc queries) 2 February 11th 06 07:26 AM
Delete rows based on multiple criterias Benson Excel Discussion (Misc queries) 8 November 2nd 05 04:11 PM


All times are GMT +1. The time now is 03:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"