I recently was trying to create a new button on my toolbars for a macro I created.
During this process a light grey box appeared which cannot be selected and you cannot
select cells behind it. This box resembles an Autoshape box that you can create, however I
can't seem to right click or left click on it. I delete the rows underneath the box but it
stays there. It only appears in one of my sheets that I had open at the time. If I copy the
sheet it will follow on to the new sheet and it also prints out with the sheet.
Any ideas on how to get rid of it? I can copy the cells and paste it to a new sheet, so this
is just a nuissance that I want to know how I created.
Naeblis
What you did was added a command button to run that macro. To delete it Press on the Design mode button on your toolbar(Button with a Green Triangle on it). Then select the command button and delete it. If you want to keep that button to run your macro, submit a reply and I will tell you how.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.
Archive of Mr Excel Message Board
