Weird One For U

brettvba · Feb 21st, 2002, 01:28 PM

Have a problem on one workbook when I have had a macro button on a worksheet and deleted it, now when ever i protect the sheet the had comes up over the whole screen and trys to run nothing cause its not there bringing up the debug screen, only happens when you remove a button from a sheet , no code is present at all even in the sheets!

Mark O'Brien · Feb 21st, 2002, 02:22 PM

Not quite following the description or question here. Could you try to explain it more?

brettvba · Feb 21st, 2002, 02:26 PM

Yeah I know the problem seems to only happen when I have had a Macro Button on the Sheet after I have removed it and when I Protect that sheet I get the little hand over the whole sheet till i Unprotect the sheet again probably just some random bug with excel I'd say?

Derek · Feb 21st, 2002, 06:23 PM

Hi there brettvba
Oh boy, do I know what you are going through. This sounds like a problem I had some time ago that frustrated the hell out of me. I think you will find that at some stage you have copied multiple buttons, possibly accidentally, by dragging, copying and pasting or whatever. Sometimes doing this can result in many buttons on top of each other. This isn't obvious until you drag a button to some other position only to find another, or in my case 15, other buttons underneath.
It gets worse if you have deleted or squashed up columns/rows the buttons can be almost invisible.
The best way to deal with this is to go to Edit,GoTo,Special...,Objects. This selects all the objects on your sheet. Sometimes you can now see where they are, drag them out and delete them individually. If not, just press Delete to get rid of them all. You will have to make new macro buttons etc to replace the ones you actually needed and reassign the macros to them.
Hope this solves your problem.
Regards
Derek

Feb 21st, 2002, 02:22 PM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Not quite following the description or question here. Could you try to explain it more? __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 21st, 2002, 01:28 PM	#1
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	Have a problem on one workbook when I have had a macro button on a worksheet and deleted it, now when ever i protect the sheet the had comes up over the whole screen and trys to run nothing cause its not there bringing up the debug screen, only happens when you remove a button from a sheet , no code is present at all even in the sheets!

Feb 21st, 2002, 02:26 PM	#3
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	Yeah I know the problem seems to only happen when I have had a Macro Button on the Sheet after I have removed it and when I Protect that sheet I get the little hand over the whole sheet till i Unprotect the sheet again probably just some random bug with excel I'd say?

Feb 21st, 2002, 06:23 PM	#4
Derek Board Regular Join Date: Feb 2002 Location: Perth Australia Posts: 1,567	Hi there brettvba Oh boy, do I know what you are going through. This sounds like a problem I had some time ago that frustrated the hell out of me. I think you will find that at some stage you have copied multiple buttons, possibly accidentally, by dragging, copying and pasting or whatever. Sometimes doing this can result in many buttons on top of each other. This isn't obvious until you drag a button to some other position only to find another, or in my case 15, other buttons underneath. It gets worse if you have deleted or squashed up columns/rows the buttons can be almost invisible. The best way to deal with this is to go to Edit,GoTo,Special...,Objects. This selects all the objects on your sheet. Sometimes you can now see where they are, drag them out and delete them individually. If not, just press Delete to get rid of them all. You will have to make new macro buttons etc to replace the ones you actually needed and reassign the macros to them. Hope this solves your problem. Regards Derek